How to upload an excel file into SAP internal tables

Excel file   Selection-Screen   Parameter to get excel file destination.   Result:     Codes:   ** Job: Upload from excel into internal table.. report  zfile_upload_from_excel. type-pools truxs. parameter p_excel type rlgrap–filename                default ‘C:EXCEL_EXAMPLE.xls’             obligatory. * Excel Structure types: begin of itab,        val1 type string,        val2 type string,        val3 type string,        end of itab. data : lt_itab type standard table of itab,        ls_itab type itab,        it_type type truxs_t_text_data. * Getting Excel File Destination at selection-screen     on value-request for p_excel. call function ‘F4_FILENAME’  exporting   field_name    = ‘P_EXCEL’  importing   file_name     = p_excel. start-of-selection. * Converting Excel File call function ‘TEXT_CONVERT_XLS_TO_SAP’  exporting   i_tab_raw_data       = it_type   i_filename           = p_excel  tables   i_tab_converted_data = lt_itab[]. end-of-selection. loop at lt_itab into ls_itab.   write:/ ls_itab–val1.   write space.   write ls_itab–val2.   write space.   write ls_itab–val3.… Continue reading How to upload an excel file into SAP internal tables