Excel OLE

[Former Member]

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.

[Former Member]

hi Sapfan,

Refer

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

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

Regards,

Santosh

[former_member189631]

Hi Fan,

Please try this FM,

/HRBP/RH_START_EXCEL_FILE_OLE

Regards,

Ramganesan K.

[Former Member]

hi

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^

[Former Member]

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

[Former Member]

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