Dynamic Excel load

[Former Member]

Hi all,

I need to read from a SAP table and create an Excel spreadsheet where the no. of columns will be dynamic.

The requirement is to read from a SAP table (which has the asset no., followed by the depreciation for the next sixty months). If the input to the program is 5, I need to create an Excel spreadsheet with 6 columns, containing the asset no. and the depreciation for the next five months.(Also, the first row need to contain the Titles, like Asset No., Month1, Month2 and so forth).

Please provide your expert and detailed advice.

Thanks,

Ani

[Former Member]

Thanks, I was able to code it. Right now, I am working on getting the headings(dynamic) into Excel.

I am planning to create the headings dynamically and insert it into the table with index 1. Please let me know if there is any other way.

(Once, I am done with the coding I can post my code)

Thanks,

Ani

[former_member188972]

Please,

have a look at this article:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/c043d836-166c...

Best Regards,

Sergio