topic Re: Office Integration - Excel Chart - Looking for Examples in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234625#M140380 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P></P><P>Laxman</P></BODY></HTML> Thu, 02 Mar 2006 18:24:16 GMT Laxmana_Appana_ 2006-03-02T18:24:16Z Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234620#M140375 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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.</P><P></P><P>Any help is appreciated.</P><P></P><P>Norm</P></BODY></HTML> Thu, 02 Mar 2006 17:16:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234620#M140375 Former Member 2006-03-02T17:16:14Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234621#M140376 <HTML><HEAD></HEAD><BODY><P>Just found some stuff in R/3... like SAPRDEMOEXCELINTEGRATION. </P><P>Still open for more suggestions!</P></BODY></HTML> Thu, 02 Mar 2006 17:22:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234621#M140376 Former Member 2006-03-02T17:22:03Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234622#M140377 <HTML><HEAD></HEAD><BODY><P>Are you wanting the graph to Excel, specifically? Or would it be OK to create it inside of SAP?</P></BODY></HTML> Thu, 02 Mar 2006 17:51:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234622#M140377 Former Member 2006-03-02T17:51:19Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234623#M140378 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this program : GFW_PROG_BAR</P><P></P><P></P><P></P><P>Laxman</P></BODY></HTML> Thu, 02 Mar 2006 18:03:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234623#M140378 Laxmana_Appana_ 2006-03-02T18:03:58Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234624#M140379 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 02 Mar 2006 18:07:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234624#M140379 Former Member 2006-03-02T18:07:38Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234625#M140380 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P></P><P>Laxman</P></BODY></HTML> Thu, 02 Mar 2006 18:24:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234625#M140380 Laxmana_Appana_ 2006-03-02T18:24:16Z Re: Office Integration - Excel Chart - Looking for Examples https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234626#M140381 <HTML><HEAD></HEAD><BODY><P>Hello Norman, </P><P></P><P>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.</P><P></P><P>Please let me know if you have already implemented this kind of requirement and can provide me with some sample code.</P><P></P><P>Regards,</P><P>Ruchi</P></BODY></HTML> Wed, 21 Nov 2007 11:31:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/office-integration-excel-chart-looking-for-examples/m-p/1234626#M140381 Former Member 2007-11-21T11:31:49Z