We have a requirement where-in we need to generate a Report Book consisting of multiple reports. Each report will be attached as a sheet in the final Report Book.
We do have a library that returns me a SpreadSheetML output for the report. Now, the challenge is to figure out a way where we have to to dynamically add the sheets and then assign the sheet with the SpreadSheetML data to the WorkBook object.
Can you please assist me in understanding if there is any solution to attach (import) spread sheet ml data onto my work book object ?
Thanks & Regards,
PS: I don’t have access to the code that returns me the Spread Sheet ML output for each report. I hand over the name for which i need the report to be generated, and i get back the fully formatted report as output.