How to write table content into excel quickly?

[Former Member]

Dear gurus, I am fresh to ABAP, could you please so kind advise how can I save a table content into an excel which is stored in certain path efficiently?

I found a way as following:

form excel_range_write using lcobj_excel

lc_range

lc_value.

data: lc_cell type ole2_object.

call method of

lcobj_excel

'RANGE' = lc_cell

exporting

#1 = lc_range.

perform font using lc_cell 1 '30'.

set property of lc_cell 'VALUE' = lc_value.

endform. "excel_cell_write

However if I would like to write everything out, I have to loop the table to fill each cell, is there any easier way? Could anyone kindly help?

[Former Member]

hi Frank

this is the wiki published by me

hope it will help u a lot

https://wiki.sdn.sap.com/wiki/display/Snippets/OLEprogramforconvertingtomultitabexcel

cheers

s.janagar