![]() Lo_excel->if_fdt_doc_spreadsheet~get_worksheet_names(ĭATA(lv_woksheetname) = lt_worksheets. ![]() Option 2 : Using class cl_fdt_xl_spreadsheet TYPES: BEGIN OF xls_line,ĭATA : lt_bin_data TYPE STANDARD TABLE OF xls_line,ĭATA(lo_excel) = NEW cl_fdt_xl_spreadsheet( However, in this option we can not read the data from a specific tab and if the file has multiple tabs it is not possible to manage the data upload using this method. REPLACE all OCCURRENCES OF ',' IN ls_data-value WITH '.'. REPLACE all OCCURRENCES OF '.' IN ls_data-value WITH ''. Lv_file TYPE string VALUE 'C:\Demo\Test.xlsx'.ĬALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'ĪSSIGN COMPONENT ls_data-col OF STRUCTURE ls_flight TO FIELD-SYMBOL(). Lt_flights TYPE STANDARD TABLE OF sflight, ![]() Click to see the sample Excel File : Test.xlsx DATA : lt_data TYPE STANDARD TABLE OF alsmex_tabline,
0 Comments
Leave a Reply. |