topic Re: Desktop Integration with Excel sheet in Application Development and Automation Discussions

Desktop Integration with Excel sheet

Former Member — Mon, 19 Jan 2009 11:52:39 GMT

Hello Everyone,

I have a requirement where in i need to create an excel document with different format and data for each cell.Here i want to use office integration control .Can anyone provide me sample code to create a spreadsheet and passing the data to it through office integration..?.

I am also looking for other option where in instead of building document from scratch,i want to use one standard template which i should be able to open and pass the data to a certain cells of this document .Is it possible to implement this functionality through desktop integration controls..? Please do the needful.

Thank you in advance.

Regards,

Venkat.

Re: Desktop Integration with Excel sheet

former_member189059 — Mon, 19 Jan 2009 11:57:35 GMT

Hello Venkat,

Search this forum for OLE

You will get plenty of examples

Re: Desktop Integration with Excel sheet

Former Member — Mon, 19 Jan 2009 12:00:27 GMT

Hello

Look at reports:

SAPRDEMOEXCELINTEGRATION

SAPRDEMOEXCELINTEGRATION2

Re: Desktop Integration with Excel sheet

Former Member — Mon, 19 Jan 2009 20:30:57 GMT

Hi,

By using OLE your code becomes very lengthy and you have to write your own

reusable subroutines. It is not suitable for complex requirement.

You can go for Desktop Office Integration (DOI) classes and their methods which serves

most of the common user requirements.

Please refer below examples

1. SAPRDEMO_SPREADSHEET_INTERFACE

2. SAPRDEMO_FORM_INTERFACE

Regards,

Vishal