How to write an internal table to Excell or word

[Former Member]

i have an internal table and how could i get the values to Excell or word .

[Former Member · Accepted solution]

You can use the method insert_one_table of interface i_oi_spreadsheet.

Check out the demo program SAPRDEMO_SPREADSHEET_INTERFACE

for further references.

You could also use insert_full method of the same inerface.

You can also create pivot tables in excel through SAP for summing up columns of your internal table. check the example SAPRDEMO_PIVOTINTERFACE for the same.

I can provide code snippets if you need.

[RichHeilman]

Please check out this weblog. Pay close attention to the reference guide at the bottom.

/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap

You can also use the function module GUI_DOWNLOAD to bring the data to an excel file.

Regards,

Rich Heilman