topic Re: Manipulating spread sheets through ABAP in Application Development and Automation Discussions

Manipulating spread sheets through ABAP

anand_nidamanuru — Thu, 09 Aug 2007 15:12:34 GMT

Hi All,

I have to save data in internal tables to multiple sheets of an existing excel file.

I want to use Document office integration interface I_OI_SPREADSHEET to achieve the same.

Below are my requirements

1) I want to open the file in the memory but it should not open a window for excel file or open in place for a screen.

2) I have to run the program in batch.

I am not able to find a way to open an existing excel and get the reference to the file. Is there a way of achieving this or I have to use OLE with ABAP?

Thanks,

Anand

Re: Manipulating spread sheets through ABAP

former_member187255 — Thu, 09 Aug 2007 15:28:21 GMT

Anand,

check this...

<a href="http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm">http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm</a>

RSOLETT1

RSDEMO01

Chandra.

Re: Manipulating spread sheets through ABAP

anand_nidamanuru — Thu, 09 Aug 2007 15:40:22 GMT

Thanks Chandra,

But this uses OLE concept. I am looking for DOI implementaion.