writing data into excel file.

[former_member1195866]

hi . i have got problem into downloading data directly to excel file. The instance that i m facing is that the header is spread over 9 lines with 13 columns and from the 10th line, data should be filled in. <i>There are some numeric field also in the data section.</i> To download data as well as header into XLSheet,i tried creating two internal tables , one for header and another for data, and then used gui_upload function module to append the data part to the header.

but since the data type is different for header and data columns. so i cudnt get any success. i have tried using OLE objects also but then dont know why the sheet is coming blank.(i m not very much aware of the OLE objects.).. so any help for providing me solution for this instance will be highly appreciable..

thanks in advance.

[Former Member]

Neha,

See the OLE object example and documention.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c1d54348-0601-0010-3e98-bd2...

Rgds,

TM

Always mark points if helpful.

Message was edited by: Thomas Mann

[Former Member]

Use ws_downlaod with type 'DAT' and it will download the data in the XL format. Make sure either you pass internal table will all column or if you have only one column with type string, the seperete all fields with haxadecimal data type 'X09'.