Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Office Integration

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

athavanraja
Active Contributor
0 Kudos

check out transaction DWDM .

DWDM->Workbench Demos->Office Integration.

Regards

Raja

11 REPLIES 11

athavanraja
Active Contributor
0 Kudos

check out transaction DWDM .

DWDM->Workbench Demos->Office Integration.

Regards

Raja

0 Kudos

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

0 Kudos

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

0 Kudos

Hi,

See this code for Microsoft integration

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

Hope this helps.

Thanks & Regards,

Judith.

0 Kudos

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

0 Kudos

Hi Jayanthi,

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

Balaji

0 Kudos

Hi Balaji,

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

0 Kudos

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

0 Kudos

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

0 Kudos

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
Active Participant
0 Kudos

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.