Passing data via OLE to existing Excel file - ABAP

Question

I'm trying to export several tables to an Excel file using OLE.

Right now, I'm developing the hole file (merging cells, borders, shades, places, etc..).

But I already have an empty file. Is it possible to use OLE to pass the data to the right places of an existing excel file?

Thank you.

Eva Dias · Accepted Answer · 2013-05-21 16:31:18Z

1

I've found the answer. Needed to use this:

* Start the application
  create object e_appl 'EXCEL.APPLICATION'.
  set property of e_appl 'VISIBLE' = 1.

* Open the file
  call method of e_appl 'WORKBOOKS' = e_work.

  call method of e_work 'OPEN'
          exporting
               #1 = p_file.

Thank you.

answered May 21, 2013 at 16:31

Eva Dias

1,75710 gold badges37 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Passing data via OLE to existing Excel file - ABAP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related