Hi,
We are using Aspose version 7.0.
We have an application where we use Aspose.Cells and Aspose.Grid to generate Excel file with data coming from various tables of the application. Following are the steps we follow to bind data to excel file(contains multiple worksheets).
We have an Excel Template created for this which we use to create workbooks.
We use asp.net for the code.
Step 1. We have a button, when we click on that button the event fires.
Step 2. DataSet is created containing multiple DataTables having values from various database tables(SQLServer).
Step 3. This DataSet is passed to new workbook created using Aspose.
Here we are facing one issue that at first time we are not geting data on workbook but when we close and reopen workbook again we are gettign data on workbook without any updation. Please see attached snap to understand better.
Thanks,
Pradnya