topic Re: writing data into excel file. in Application Development and Automation Discussions

writing data into excel file.

former_member1195866 — Fri, 21 Jul 2006 15:55:04 GMT

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.

Re: writing data into excel file.

Former Member — Fri, 21 Jul 2006 15:58:22 GMT

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-bd2a2dcd9e6c

Rgds,

Always mark points if helpful.

Message was edited by: Thomas Mann

Re: writing data into excel file.

Former Member — Fri, 21 Jul 2006 16:57:45 GMT

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'.