08-22-2011 7:04 AM
hi,
I need to read data from input excel sheet. But the problem here is everytime the number of columns will vary.
The FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' will ask for the row number and column number which is not known and hence of no help.
Is there any other way to do this using ABAP?
08-22-2011 9:11 AM
Do you know at least a maximum row and column range of the Excel data? This function uses the clipboard to get the data into ABAP, and as far as I know, you can copy a larger range, empty cells will then be ignored. Give it a try.
Thomas
08-22-2011 7:08 AM
08-22-2011 9:11 AM
Do you know at least a maximum row and column range of the Excel data? This function uses the clipboard to get the data into ABAP, and as far as I know, you can copy a larger range, empty cells will then be ignored. Give it a try.
Thomas
08-22-2011 12:41 PM
Hi both,
Thanks a lot for the replies.
Hi Thomas,
I have been trying your suggestion and it works ok for me unless no cell is empty. But if some cell in middle is empty then it skips that which creates again problem for me.