topic Re: Excel OLE in Application Development and Automation Discussions

Excel OLE

Former Member — Tue, 20 Mar 2007 08:35:01 GMT

Hi all,

I need to export three different tables to a excel file on application server.

any ideas how to do this.

also could any one pass me the copy of 'An easy reference to OLE automation'.The link to this resource is not working any more.

thanks in advance.

Re: Excel OLE

Former Member — Tue, 20 Mar 2007 08:38:47 GMT

hi Sapfan,

Refer

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

http://www.sapdevelopment.co.uk/file/file_uploadsap.htm

Regards,

Santosh

Re: Excel OLE

former_member189631 — Tue, 20 Mar 2007 08:38:59 GMT

Hi Fan,

Please try this FM,

/HRBP/RH_START_EXCEL_FILE_OLE

Regards,

Ramganesan K.

Re: Excel OLE

Former Member — Tue, 20 Mar 2007 08:41:43 GMT

good

ALE Automation->

http://help.sap.com/saphelp_46c/helpdata/en/59/ae3c98488f11d189490000e829fbbd/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/4f/9937f1446d11d189700000e8322d00/content.htm

thanks

mrutyun^

Re: Excel OLE

Former Member — Tue, 20 Mar 2007 08:49:12 GMT

Sap fan,

DATA : FNAME(255) TYPE C VALUE '/data/sapdata/eu_ums/astdetails.xls'.

CONSTANTS : C_COMMA TYPE C VALUE ','.

*****Adding Column names to output

I_FINAL-DOCNUM = 'IDOCNO'.

I_FINAL-STATXT = 'ERROR TEXT'.

I_FINAL-STAPA1 = 'ERROR DETAILS'.

I_FINAL-QMNUM = 'NOTIFICATION'.

I_FINAL-ZASSETCLASS = 'ASSETCLASS'.

I_FINAL-ZDATACODE = 'DATACODE'.

I_FINAL-ZMFRCODE = 'MANUFACTURER'.

I_FINAL-ZMODELCODE = 'MODELCODE'.

I_FINAL-ZSERNO = 'SERIALNO'.

INSERT I_FINAL INDEX 1.

CLEAR I_FINAL.

LOOP AT I_FINAL.

CONCATENATE

I_FINAL-DOCNUM

I_FINAL-STATXT

I_FINAL-STAPA1

I_FINAL-QMNUM

I_FINAL-ZASSETCLASS

I_FINAL-ZDATACODE

I_FINAL-ZMFRCODE

I_FINAL-ZMODELCODE

I_FINAL-ZSERNO

into I_DISPLAY-REC SEPARATED BY C_COMMA.

APPEND I_DISPLAY.

CLEAR I_DISPLAY.

ENDLOOP.

OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE.

LOOP AT I_DISPLAY.

TRANSFER I_DISPLAY TO FNAME.

ENDLOOP.

CLOSE DATASET FNAME.

Pls. reward if useful

Re: Excel OLE

Former Member — Tue, 20 Mar 2007 09:19:25 GMT

hi,

thanks everyone.

I want to see all the attributes and methods of object EXCEL.

In the examples available in the net, they use only few attributes. where do I get the list of all attributes?

Thanks