Upload excel data into Internal table

[Former Member]

Hi,

I'm trying to upload excel data into internal table, well the excel file layout will be different on each run of the report.

Excel file will have 60 columns and 500 record limit. I can upload the excel data using 'ALSM_EXCEL_TO_INTERNAL_TABLE' and 'KCD_EXCEL_OLE_TO_INT_CONVERT' but the output table is generates 60 lines for each record i.e.., 60 * 500 = 30,000 which could cause performance.

I try with the FM 'TEXT_CONVERT_XLS_TO_SAP', but this will only work if the file structure is static. It didn't work for dynamic file layout. Even GUI_UPLOAD doesn't work to upload excel file, it will work if I convert the file to Tab delimited file.

Please advise if you know any alternate procedure to upload excel data into internal table.

Thanks,

Kumar.

[Former Member]

Moderator message - Cross post locked Rob