Skip to Content
0
Former Member
Aug 26, 2009 at 08:00 AM

BDC method (excel file row and colums are not constant_

21 Views

Hi Experts,

I am uploading data from flat file to sap application by using bdc method. My flat file is in excel format.

Now my problem is the no. of rows and cloums are not constant in my excel file.when i am using ALSM_EXCEL_TO_INTERNAL_TABLE functional module i need to pass values to i_begin_col, i_begin_row, i_end_col and i_end_row parameters.how can i change the no.of rows and colums dynamically in my program based on exel file.

will you suggest me with coding.

Thanks in advance,

Mythily