Internal table data into Excel sheet with header

[Former Member]

Hi

I have created a report and i want to down load the data into Excel file.

I have used the function modules like SAP_CONVERT_TO_XLS_FORMAT, MS_EXCEL_OLE_STANDARD_DAT. In my excel sheet I am not getting Header.

After i have used function module XXL_FULL_API.

Is any other function module or BAPI that can import data into excel sheet with header data.

Thanks

[Former Member]

Hi,

Please chec the below links :

http://help.sap.com/erp2005_ehp_04/helpdata/EN/fa/77f944a5f411d1a8c70000e8a5b574/frameset.htm

http://help.sap.com/erp2005_ehp_04/helpdata/EN/aa/f73e4045796913e10000000a1550b0/frameset.htm

Regards

Sreedhar Reddy

[Former Member]

Hi sreedhar,

I have used PIVOT table, for function module XXL_FULL_API to dispaly header data.

It works well.

Can you suggest any other solutions.

Thanks.