Reading data from excel file whose number of columns are not fixed

[Former Member]

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?

[Former Member]

Hi

I found a [link|;, this might be helping you in this case.

[ThomasZloch]

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

[Former Member]

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.