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,