Office Integration

[Former Member]

Hi Guys,

Recently i was trying to format an excel file from SAP, which i did using OLE. But at the time of doing that, i found that the performance is taking a back seat. I also felt that there might be some better way of doing the integration of MS Office with SAP.

So can anyone suggest how i can achieve that using DOI? Can anyone explain how i can go about learning DOI? If you have any simple example, like how to start an empty excel file and then fill it with data, say from an internal table in one of the sheet; filling the data of another internal table in another sheet but in the same excel file and then format it.

I also heard that it can be achieved using ALV? Any idea?

Any help on this regard is greatly appreciated.

Thanks & Regards

Balaji G

[athavanraja]

check out transaction DWDM .

DWDM->Workbench Demos->Office Integration.

Regards

Raja

[Former Member]

Hi

Thanks Raja & Ellay for your suggestions.

Can anyone tell me how to actually populate data in the excel file that has been created. I am trying to use i_oi_spreadsheet to actually access the spreadsheet.

If you can give me some sample code, that would be great.

Any help on this regard is greatly appreciated.

Thanks & Regards

Balaji

[jayanthi_jayaraman]

Hi Balaji,

Check this link.

http://www.sap-img.com/abap/abap-object-oriented-spreadsheet-with-unlimited-power.htm

Hope this is useful for your requirement.

Check this also.

http://sap.ittoolbox.com/code/d.asp?d=3027&a=s

Regards,

J.Jayanthi

[Former Member]

Hi,

See this code for Microsoft integration

http://www.sapdevelopment.co.uk/ms/ms_excel.htm

Hope this helps.

Thanks & Regards,

Judith.

[Former Member]

Hi,

Check out this link to use i_oi_spreadsheet for accessing spreadsheet.

http://help.sap.com/saphelp_47x200/helpdata/en/21/b53144e1ba11d2bdbe080009b4534c/frameset.htm

Regards,

Anjali

[Former Member]

Hi Jayanthi,

Thanks for the valuable piece of information. Will try it out and i do face any problems, will definitely trouble you.

Balaji

[jayanthi_jayaraman]

Hi Balaji,

Sorry.I just gave the link.No idea about it.

[Former Member]

Hi

What advantage does the implementation using i_oi_spreadsheet provide over the usage of OLEs?

If i want to download data from ALV to excel without using the standard one, how can i achieve that.

Apart from using OLEs and i_oi_spreadsheer interface, is there any other way to populate and format data in excel?

Any pointers on this regard is greatly appreciated.

Thanks

Balaji

[jayanthi_jayaraman]

Hi,

You can GUI_DOWNLOAD and WS_DOWNLOAD to populate data in excel.

Check this link also.

http://www.sap.info/index.php4?ACTION=noframe&url=http://www.sap.info/public/en/index.php4/article/c...

Message was edited by: Jayanthi Jayaraman

[Former Member]

Hi Balaji,

You can do this:

1. Set a range in the spreadsheet using the INSERT_RANGE method.

2. Set the data in the range using the SET_RANGES_DATA method.

(I think you can also just use the SET_DATA_TABLE method).

Cheers,

Martin

[eyal_alsheikh]

Hi Balaji,

The SAP documentation can help you:

http://help.sap.com/saphelp_47x200/helpdata/en/e9/0bee9f408e11d1893b0000e8323c4f/frameset.htm

Focus on the spreadsheet interface.

You can also see the examples in the SOFFICEINTEGRATION

package under programs.

Hope it helps,

Eyal.