Defining Excel File End

[Former Member]

Hi all

I am writing below code in my program.I don't know exactly the no of last row in my excel sheet.No of rows in my excel sheet are not constant.so please tell me how to specify the end of the row.

Thank you.

• Downloading data from Excel sheet.

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'

exporting

filename = fname

i_begin_col = 1

i_begin_row = 1

i_end_col = 15

i_end_row = 6000

tables

intern = excel_tab.

Regards

Giri.

[Former Member]

U can specify end_of_row as 65535.

Have a look at below link and serach for the FM ALSM_EXCEL_TO_INTERNAL_TABLE

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+general&;

I hope it helps.

Best Regards,

Vibha

<b>*Please mark all the helpful answers</b>

[sreeramkumar_madisetty]

Hi

U can specify end_of_row as 65535.

Regards,

kumar

[Former Member]

Hi,

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'
exporting
filename = fname
i_begin_col = 1
i_begin_row = 1
i_end_col = 15
i_end_row = 65535
tables
intern = excel_tab.

The excel contains 65535 records in a sheet ..

Regards

Sudheer