OLE ABAP - multitab Excel

[kunal1812]

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.

[abo]

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.

[Sandra_Rossi]

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