error in uploading from excel

[Former Member]

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

[Former Member]

Hi

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

THANKS

SABYASACHI

[Former Member]

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

[Former Member]

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

[Former Member]

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