Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Desktop Integration with Excel sheet

Former Member

‎2009 Jan 19 11:52 AM

0 Likes
584

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.

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.

Reply
3 REPLIES 3
Read only

former_member189059
Active Contributor

‎2009 Jan 19 11:57 AM

0 Likes
554

Hello Venkat,

Search this forum for OLE

You will get plenty of examples

Read only

Former Member

‎2009 Jan 19 12:00 PM

0 Likes
554

Hello

Look at reports:

SAPRDEMOEXCELINTEGRATION

SAPRDEMOEXCELINTEGRATION2

Read only

Former Member

‎2009 Jan 19 8:30 PM

0 Likes
554

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