

Lo_xml_document->parse_xstring( lo_sheet_content ).ĭATA(lo_node_datavalidation_init) = lo_node_datavalidations->clone( ).ĭATA(lo_node_datavalidation) = lo_node_datavalidation_init->clone( ). Lo_sheet_content = lo_wordsheetpart->get_data( ). Lo_wordsheetpart = lo_wordsheetparts->get_part( 0 ). Lo_wordsheetparts = lo_workbookpart->get_worksheetparts( ).

Lo_workbookpart = lo_xlsx_doc->get_workbookpart( ). On the other hand, you can set document format by using IF_IXML_NODE, below example code show how … lo_xlsx_doc = cl_xlsx_document=>load_document( ) A good example code can be found within class CL_EHFND_XLSX(available on ABAP AS 752 SP-Level 0004, Software Component S4CORE Release 102, SP 4.). In this Blog-post I’d like to give a few insights on how we process XLSX file by using latest ABAP, which might be quite different than in most other implementations, for example: ABAP and OLE or Excel with SAP – An Overviewīy using CL_XLSX_DOCUMENT (available from 2008), it is easy to load file, workbook, sheets, rows and columns.
