topic Upload excel data into Internal table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/upload-excel-data-into-internal-table/m-p/6919970#M1484110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to upload excel data into internal table, well the excel file layout will be different on each run of the report.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P></P><P>Please advise if you know any alternate procedure to upload excel data into internal table.</P><P></P><P></P><P>Thanks,</P><P>Kumar.</P></BODY></HTML> Sat, 01 May 2010 21:44:39 GMT Former Member 2010-05-01T21:44:39Z Upload excel data into Internal table https://community.sap.com/t5/application-development-and-automation-discussions/upload-excel-data-into-internal-table/m-p/6919970#M1484110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to upload excel data into internal table, well the excel file layout will be different on each run of the report.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P></P><P>Please advise if you know any alternate procedure to upload excel data into internal table.</P><P></P><P></P><P>Thanks,</P><P>Kumar.</P></BODY></HTML> Sat, 01 May 2010 21:44:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upload-excel-data-into-internal-table/m-p/6919970#M1484110 Former Member 2010-05-01T21:44:39Z Re: Upload excel data into Internal table https://community.sap.com/t5/application-development-and-automation-discussions/upload-excel-data-into-internal-table/m-p/6919971#M1484111 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Cross post locked Rob</SPAN></P></BODY></HTML> Sat, 01 May 2010 22:16:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/upload-excel-data-into-internal-table/m-p/6919971#M1484111 Former Member 2010-05-01T22:16:50Z