topic Re: Opening Excel Spreadsheet from ABAP in Application Development and Automation Discussions

Opening Excel Spreadsheet from ABAP

Former Member — Fri, 07 Jan 2005 20:27:31 GMT

Hello,

Is there any way to put data from an ABAP program into an existing Excel spreadsheet? I know how to put the data into a new spreadsheet but my users want to put the data into an existing spreadsheet where they have developed macros.

Thanks,

Becky

Re: Opening Excel Spreadsheet from ABAP

RichHeilman — Fri, 07 Jan 2005 20:47:27 GMT

You are going to want to look into OLE2 controls.

Check demo program RSDEMO01. I am using 46c.

Good luck,

Rich Heilman

Re: Opening Excel Spreadsheet from ABAP

Former Member — Sat, 08 Jan 2005 06:10:30 GMT

Hi Rebecca,

you can open the Excel file in append mode, that will help you to retain the previous entries. Then in case of the Macro, i am not sure about that, if i find anything i will let you know.

Regards,

Kathirvel.

Re: Opening Excel Spreadsheet from ABAP

ssimsekler — Sun, 09 Jan 2005 14:09:13 GMT

Hi Becky

Here is a procedure using OLE automation.


DATA gs_excel TYPE ole2_object .
DATA gs_wbooks TYPE ole2_object .
DATA gs_wbook TYPE ole2_object .
DATA gs_application TYPE ole2_object .

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .
SET PROPERTY OF gs_excel 'Visible' = 1 .
GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooks .
GET PROPERTY OF gs_wbooks 'Application' = gs_application .

*--Opening the existing document
CALL METHOD OF gs_wbooks 'Open' = gs_wbook
     EXPORTING #1 = <file_path_var> .

"*--After this point you can go on processing the sheet
using OLE Automation techniques"

If it is just the template to be stored you can save the template .xls file at the application server each time downloading it to a temporary place to open. Or you can store it at SAP Office templates folder. For SAP Office operations you can inspect "BC_SO_*" masked FMs.

And as a last thing, let me introduce you the SDN forums pointing system: You can assign points to posts you find helpful while solving your question. You can reward points by clicking the yellow star icon at header of each reply post. You can reward;

- one 10 points (solved)

- two 6 points (very helpful answer)

- many 2 points (helpful answer)

Kind Regards...

*--Serdar

Re: Opening Excel Spreadsheet from ABAP

Former Member — Fri, 04 Mar 2005 10:12:18 GMT

I'm using the same technique to run a macro in excel which selects a tab to become active.

However, I need it to save excel & return to SAP, but I'm left in Excel. Do you know how to do this please?

Thanks

Sunni

Re: Opening Excel Spreadsheet from ABAP

eddy_declercq — Fri, 04 Mar 2005 10:19:47 GMT

Pls also check Thomas Jung Weblogs

/people/thomas.jung3/blog/2005/02/14/bsp-and-microsoft-excel--learning-to-live-together

/people/thomas.jung3/blog/2005/02/23/bsp-and-microsoft-excel--learning-to-live-together-part-2

Re: Opening Excel Spreadsheet from ABAP

Former Member — Fri, 04 Mar 2005 10:40:19 GMT

The code is below, it leaves me in Excel after running the macro rather than returning to my ABAP??

DATA gs_excel TYPE ole2_object .

DATA gs_wbooks TYPE ole2_object .

DATA gs_wbook TYPE ole2_object .

DATA gs_application TYPE ole2_object .

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .

SET PROPERTY OF gs_excel 'Visible' = 1 .

GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooks .

GET PROPERTY OF gs_wbooks 'Application' = gs_application .

*--Opening the existing document

CALL METHOD OF gs_wbooks 'Open' = gs_wbook

EXPORTING #1 = 'C:\BOOK1.XLS'.

CALL METHOD OF GS_EXCEL 'RUN' EXPORTING #1 = 'MACRO4'.

FREE OBJECT EXCEL.

???

Re: Opening Excel Spreadsheet from ABAP

Former Member — Tue, 22 Mar 2005 21:13:50 GMT

Sunni,

may I ask you how do you define your 'MACRO4'?

Is this excel macro or ABAP macro?

Thanks,

Maria