topic Re: error in uploading from excel in Application Development and Automation Discussions

error in uploading from excel

Former Member — Mon, 04 Feb 2013 06:45:20 GMT

Hi Experts,

I am creating a report in which I have to upload values from excel sheet to the internal table. I am getting a dump. I debugged it. Its because its picking up the heading as well. I want to pick from the 2nd line. Pl guide.

I am using the FM ALSM_EXCEL_TO_INTERNAL_TABLE

I have changed the

I_BEGIN_ROW = 2 as well but still not working.

Regards

Purnand

Re: error in uploading from excel

Former Member — Mon, 04 Feb 2013 06:57:21 GMT

if you use F4_filename then it put under AT SELECTION-SCREEN ON VALUE-REQUEST FOR (FIELDNAME). EVENT.

THANKS

SABYASACHI

Re: error in uploading from excel

Former Member — Mon, 04 Feb 2013 07:01:32 GMT

Hi Purnand,

For uploading the excel file...remove the header details and then upload bcoz ur internal table is interested to pick ur records only..right?? bcoz the header details would be type "string" and ur fields will be from some data elements like VBELN, MATNR etc...these fields will not accept ur header data..

Reward points if helpful

Re: error in uploading from excel

Former Member — Mon, 04 Feb 2013 07:15:35 GMT

Hi Purnand,

" Type conflict when calling a function module." r u getting this dump ?

if 'Yes' then check your selection screen field type mean ..

Example :

PARAMETERS: P_FILE LIKE RLGRAP-FILENAME,

W_BEGIN TYPE C OBLIGATORY, if Begin type 'C' then change into 'I' W_END TYPE C OBLIGATORY.

Correct one :

PARAMETERS: P_FILE LIKE RLGRAP-FILENAME,

W_BEGIN TYPE I OBLIGATORY,

W_END TYPE I OBLIGATORY.

Regard's

Smruti

Re: error in uploading from excel

Former Member — Mon, 04 Feb 2013 07:20:01 GMT

I cant remove it. I will always get the excel file with the heading. I appreciate your reply. I have got the solution