topic Re: Getting the header as first record while uploading excel file using bdc in Application Development and Automation Discussions

Getting the header as first record while uploading excel file using bdc

Former Member — Thu, 31 Dec 2009 11:14:04 GMT

Hi all,

I am new to abap. I have created a bdc program to upload an excel file for updating esi no in pa30. The excel sheet has the header as first row(like eno,esino,etc). Whlle debugging i c that the first record takes the heading values. How can this be rectified.

I am using ALSM_EXCEL_TO_INTERNAL_TABLE function for uploading the excel file.

Please help me resolving this issue otherwise the program is working fine.

Thanks in regards,

Ashok

Re: Getting the header as first record while uploading excel file using bdc

JoffyJohn — Thu, 31 Dec 2009 11:19:44 GMT

set i_begin_row = 2

in function module

to read from second row of excel

Re: Getting the header as first record while uploading excel file using bdc

Former Member — Thu, 31 Dec 2009 11:25:51 GMT

Hi Ashok ,

You can set the paramater I_BEGIN_ROW in the FM as 2.

Regards,

Arun