Download Excel: col_text of XXL_SIMPLE_API

[Former Member]

Hi Gurus,

I am using XXL_SIMPLE_API for output to Excel.

My requirement is to populate the content into Excel WITHOUT any header. Based on my analysis, whenever I leave the col_text table blank, XXL_SIMPLE_API function will return exception dim_mismatch_data. Having said so, the col_text is compulsory to have.

My question - is there any way I can use the same function XXL_SIMPLE_API without the header populated.

[arindam_m]

Hi,

Copy the Function Module and make a Z-Function module and comment the lines below in the code:

IF ( N_KEY_COLS LE 0 ) OR
    ( N_KEY_COLS GE N_DAT_COLS ) OR
    ( L_COL_TEXT NE N_DAT_COLS ).
   RAISE DIM_MISMATCH_DATA.
 ENDIF.

Should be the shortest way to get around it. Inside the FM XXL_FULL_API uses the info but the tables is optional so you can skip passing the value.

Cheers,

Arindam

[Former Member]

Not a bad idea. But I would go for another alternative which is to append the first line of my record as header to overcome this restriction.