Manipulating spread sheets through ABAP

[anand_nidamanuru]

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

[former_member187255]

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.

[anand_nidamanuru]

Thanks Chandra,

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