Load SpreadSheet ML Data onto Work Sheet

Aspose.Cells Product Family
1

Hi,


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,
Anil
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.


2

Hi,


I am not completely sure about your requirement and there is no options available in MS Excel either which allows you directly attach your spreadsheetml sheet to be attached in the final book sheet.
I think you may try:
You may copy the sheets in his spreadsheetml file to be pasted in the final report book. You should read spreadsheetml file in the workbook object, then copy it to the destination workbook

See some topics:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/opening-files.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/copying-and-moving-worksheets.html

Thank you.