topic Re: Office Integration in Application Development and Automation Discussions

Office Integration

Former Member — Sat, 21 May 2005 08:27:03 GMT

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

Re: Office Integration

athavanraja — Sat, 21 May 2005 08:48:05 GMT

check out transaction DWDM .

DWDM->Workbench Demos->Office Integration.

Regards

Raja

Re: Office Integration

eyal_alsheikh — Sun, 22 May 2005 10:53:37 GMT

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.

Re: Office Integration

Former Member — Mon, 23 May 2005 06:58:23 GMT

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

Re: Office Integration

jayanthi_jayaraman — Mon, 23 May 2005 08:00:08 GMT

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

Re: Office Integration

Former Member — Mon, 23 May 2005 08:09:10 GMT

Hi,

See this code for Microsoft integration

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

Hope this helps.

Thanks & Regards,

Judith.

Re: Office Integration

Former Member — Mon, 23 May 2005 09:13:09 GMT

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

Re: Office Integration

Former Member — Tue, 24 May 2005 08:40:20 GMT

Hi Jayanthi,

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

Balaji

Re: Office Integration

jayanthi_jayaraman — Tue, 24 May 2005 08:42:02 GMT

Hi Balaji,

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

Re: Office Integration

Former Member — Thu, 26 May 2005 12:21:54 GMT

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

Re: Office Integration

jayanthi_jayaraman — Thu, 26 May 2005 12:25:32 GMT

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/comvArticle-193333c63b4bd807d2/en/articleStatistic

Message was edited by: Jayanthi Jayaraman

Re: Office Integration

Former Member — Thu, 26 May 2005 12:32:34 GMT

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