topic OLE ABAP - multitab Excel in Application Development and Automation Discussions

OLE ABAP - multitab Excel

kunal1812 — Mon, 14 Nov 2022 10:41:00 GMT

Hi,

I am using OLE to get the internal table data into multiple sheets of the same excel.

But i found out that, my first sheet is coming up blank when i run it, on the other side if i run it in debugging mode step by step then the first sheet is getting filled up.

any solution to get the first sheet filled up evrytime,

or is it because of a manual delay to the creation of new sheet during the debugging mode , if so then is there any OLE method to add wait for the next sheet creation until the completion of the previous sheet.

Thank you.

Re: OLE ABAP - multitab Excel

abo — Mon, 14 Nov 2022 11:53:29 GMT

If this is a new development, you could use abap2xlsx and avoid the pain 🙂

The current version comes with a method to import a whole tab / sheet at once.

Re: OLE ABAP - multitab Excel

Sandra_Rossi — Mon, 14 Nov 2022 12:41:38 GMT

If you ask a question about code, people will better understand if you share the code too.