topic Re: Dynamic Excel load in Application Development and Automation Discussions

Dynamic Excel load

Former Member — Sat, 09 Dec 2006 07:50:20 GMT

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

Re: Dynamic Excel load

Former Member — Sun, 10 Dec 2006 07:46:36 GMT

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

Re: Dynamic Excel load

former_member188972 — Wed, 13 Dec 2006 18:29:48 GMT

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-2910-b99e-ae3633dec547

Best Regards,

Sergio