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

Office Integration - Excel Chart - Looking for Examples

Former Member

‎2006 Mar 02 5:16 PM

0 Likes
945

I am using the Office Integration (OI) classes/methods in an ABAP program. It creates a large multi-tabbed Excel workbook with statistical data. I need to graph the data in some of the worksheets.

I am looking for code examples to create a bar chart. I think the method call GET_DOCUMENT_PROXY in the I_OI_CONTAINER_CONTROL interface has to use the 'Excel.Chart' document_type. I am using 'Excel.Sheet' right now. Can't find any examples or references.

Any help is appreciated.

Norm

I am using the Office Integration (OI) classes/methods in an ABAP program. It creates a large multi-tabbed Excel workbook with statistical data. I need to graph the data in some of the worksheets.

I am looking for code examples to create a bar chart. I think the method call GET_DOCUMENT_PROXY in the I_OI_CONTAINER_CONTROL interface has to use the 'Excel.Chart' document_type. I am using 'Excel.Sheet' right now. Can't find any examples or references.

Any help is appreciated.

Norm

Reply
6 REPLIES 6
Read only

Former Member

‎2006 Mar 02 5:22 PM

0 Likes
854

Just found some stuff in R/3... like SAPRDEMOEXCELINTEGRATION.

Still open for more suggestions!

Read only

Former Member

‎2006 Mar 02 5:51 PM

0 Likes
854

Are you wanting the graph to Excel, specifically? Or would it be OK to create it inside of SAP?

Read only

Laxmana_Appana_
Active Contributor

‎2006 Mar 02 6:03 PM

0 Likes
854

Hi,

Check this program : GFW_PROG_BAR

Laxman

Read only

Former Member
In response to Laxmana_Appana_

‎2006 Mar 02 6:07 PM

0 Likes
854

Thanks guys, but I have to use MS Excel. The file is going to be downloaded and emailed via SAPconnect. The client wants an Excel format.

Read only

Laxmana_Appana_
Active Contributor
In response to Laxmana_Appana_

‎2006 Mar 02 6:24 PM

0 Likes
854

Hi,

You can do this with 'Excel.Application' object , try to create the macro in excel according to your requirement and then get the code from excel macro with edit operation and then call same methods from ABAP.

Laxman

Read only

Former Member
In response to Laxmana_Appana_

‎2007 Nov 21 11:31 AM

0 Likes
854

Hello Norman,

I have a similar requirement as your, I have created a multi-tabbed excel sheet using EXCEL.APPLICATION and need to put graphs in some excel.

Please let me know if you have already implemented this kind of requirement and can provide me with some sample code.

Regards,

Ruchi