![]() ![]() I can convert this file using online converter to XLSX format which opens in Google Sheets along with color formatting. This file however does not open up in Google Sheets. Choose the best choice in the Import file box, then click Import data. Sheets documents contain two crossed lines, while Excel documents have an x. Click Upload and follow the on-screen instructions to upload or drag and drop it. Ns_attribute = l_document->create_namespace_decl( name = 'x' prefix = 'xmlns' uri = 'urn:schemas-microsoft-com:office:excel' ).ĬALL METHOD cl_gui_frontend_services=>gui_download Open your Sheet, then select File, then Import. L_element_root->set_attribute_node( ns_attribute ). Ns_attribute = l_document->create_namespace_decl( name = 'ss' prefix = 'xmlns' uri = 'urn:schemas-microsoft-com:office:spreadsheet' ). L_element_root->set_attribute( name = 'xmlns' value = 'urn:schemas-microsoft-com:office:spreadsheet' ). L_element_root = l_document->create_simple_element_ns( name = 'Workbook' parent = l_document ). Though most files work, we have one program which downloads an ALV report using XML color formatting as per requirement. All I would need is the file atleast opens up in Google Sheets when I upload it ( not directly save from SAP to Google ). I have gone through blogs on Google Sheet and SAP Integration using OAuth and it needs upgraded system and looks like a standard solution. So now we require all our files to open up in Google Sheets. We just moved from using Excel to Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |