Free Support Forum - aspose.com

Multiple Datatables and Smart Markers

I have a situation where I have multiple datagrids on one page. I need to import alll of the grids into one formatted spreadsheet. Each datagrid has different number of columns and different data types.

Is it possible to use Smart Markers using multiple grids or datatables? I tried using the following, but only the first datatable posted to the spreadsheet. Table2 did not post. Any suggestions?

wb.SetDataSource(dtTable1)

wb.Process()

wb.SetDataSource(dtTable2)

wb.Process()

wb.Save("MyOutput.xls", SaveType.OpenInExcel, FileFormatType.Default, Response)

Hi,

Thanks for considering Aspose.

Yes, quite possible. Please use wb.Process() only once and at last after setting all your datasources.

E.g.,

wb.SetDataSource(dtTable1)

wb.SetDataSource(dtTable2)

wb.Process()

wb.Save("MyOutput.xls", SaveType.OpenInExcel, FileFormatType.Default, Response)

Thank you.

Works like a charm! Thanks!