Read Excel file and transfer data into internal table

There are situations where we need to read the data from excel file into internal table. We can use GUI_UPLOAD for csv files but in case of excel formats , this FM fails.

In case of excel file formats(XLS, and XLSX) , then we can use FM 'TEXT_CONVERT_XLS_TO_SAP'.




If you want to skip the header row pass 'X' to i_line_header. p_file is the path of the file in presentation server(user's computer) it_table is the internal table where data will be transferred.