Monday, November 07, 2005

SAP R/3 : Converting EXCEL into Internal Table

Recently, i got an email requesting that how would one convert an EXCEL format report into SAP file system (internal table). Normally, ABAPer can use WS_UPLOAD to upload that file from EXCEL provided that the EXCEL is saved as DAT or CSV. However, there are times that we just want to convert or get data straight from the EXCEL file itself. Yes, there are many ways to do it.

To do that, one can use function 'ALSM_EXCEL_TO_INTERNAL_TABLE'. This function will extract all data into one standard internal table call alsmex_tabline. This standard internal table will require ABAPer to filter the data so it can be used. Still, when you have done this portion, just be aware of how you will need to upload again from text file to be used in BDC or other process.
sky is not the limit...

1 comment:

Anonymous said...

Only for cells with <=255 characters (there's no standard way of uploading cells with > 255 characters)