Similarly dynamic structure names can also be provided for the same. In the below example the dynamic internal tables are converted into header and items strucutres. Once the Data has been read into two different internal tables use the below methods to the read the data and process it. Lo_data_ref = lo_excel_ref->if_fdt_doc_spreadsheet~get_itab_from_worksheet( READ TABLE lt_worksheets INTO lv_woksheetname INDEX 2. *- Excel work sheet data in dyanmic internal table READ TABLE lt_worksheets INTO DATA(lv_woksheetname) INDEX 1.ĭATA(lo_data_ref) = lo_excel_ref->if_fdt_doc_spreadsheet~get_itab_from_worksheet(
Lo_excel_ref->if_fdt_doc_spreadsheet~get_worksheet_names(
Lo_excel_ref = NEW cl_fdt_xl_spreadsheet( WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.ĭATA : lo_excel_ref TYPE REF TO cl_fdt_xl_spreadsheet. MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno Use the method IF_FDT_DOC_SPREADSHEET~GET_ITAB_FROM_WORKSHEET to get the corresponding tab into internal table by passing the sheet or tab number.IF_FDT_DOC_SPREADSHEET~GET_WORKSHEET_NAMES returns both the tabs as internal tables.In Odata use the CREATE_STREAM method to write the below code.Use the Class CL_FDT_XL_SPREADSHEET in order to over come the above issue by instantiating and passing the XSTRING data in the constructor.The below code can be leveraged to upload and read the excel with multiple excel tabs or worksheets. This function module which uses OLE object for Office Integration solution internally will produce a dump and is not supported when used in the SAP ABAP Program Odata when called from Fiori launch pad since this is web based HTTP application with WEBGUI and no OLE is supported similar to the SAP GUI.ĭisadvantages of using the ALSM_EXCEL_TO_INTERNAL_TABLE,TEXT_CONVERT_XLS_TO_SAP FM : This will work fine when we test the program or Odata from SAP GUI. There has been multiple instances where most of the developers tend to use the function module ALSM_EXCEL_TO_INTERNAL_TABLE,TEXT_CONVERT_XLS_TO_SAP. There could be multiple scenarios where an excel upload and download using ABAP Report Program or a Odata service with different sheets or tabs in a Excel needs to developed as shown in the below screenshot.
0 kommentar(er)
