Export data to excel along with Formulas

[Former Member]

Hi,

I want to design a WD ABAP table ALV or normal) with a forumula for each cell like we do in excel. And upon clicking export to excel it should export the data in the table along with the formulas in it. Is it possible?

Aditya.

[ChrisPaine · Accepted solution]

NB if you do use the standard ALV you'll have to disable the standard export and build your own. I wonder how long (or perhaps it has already happened - Ivan could probably tell us) it will take for generic export from Web Dynpro ALV code to be available.

I've played with the exports that Ivan has been working on. They are very cool and I highly recommend them!

Cheers,

Chris

[Former Member · Accepted solution]

Thanks. I am closing the thread. Our requirement is dropped.

[_IvanFemia_]

Hi,

try to read these blogs

[abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

[xlsx2abap - Read and edit your Excel files from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20791] [original link is broken] [original link is broken] [original link is broken];

Code of this SCN Community project is shared on [Code Exchange|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Regards

Ivan

[krishnendu_laha]

I am afraid, it's not possible...