downloading Excel format data to application server.

[Former Member]

Hi Frnds,

Is there any "Function module" to write the data(internal table) into "Application server in EXCEL" format.

Or sample code will also be useful

Many thanks in advance.

Karthick.C

[Laxmana_Appana_]

Hi,

Use Open data set method to create file on application server with '.xls' extension

check this link :

Regards

appana

[Manohar2u]

Hope this sample program helps you.

http://www.sap-img.com/abap/download-in-background-in-excel-format.htm

Regds

Manohar

[Former Member]

hi,

U cant download data to application server in XL format.

u have to use Dataset .

U can only download data in XL format on presentation server.

FM :- GUI_DOWNLOAD

[Former Member]

Hi,

You can use <b>MS_EXCEL_OLE_STANDARD_DAT</b> function module.

For more detail you can refer to below thread, this will definitely solve your problem:

<b>Reward if helpful</b>

Rgds,

Shakuntala