We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Random issue - Data not seen on Workbook

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We are using Aspose version 7.0.

We have an application where we use Aspose.Cell 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.<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" />




We recommend you to kindly try our latest version/fix: Aspose.Cells for .NET v8.3.0, you may download the MSI installer to install Aspose.Cells component and Aspose.Cells.GridWeb control v8.3.0 from here:

If you still find the issue, kindly create a simple project (runnable) with Aspose.Cells v8.3.0.x and Aspose.Cells.GridWeb v8.3.0.x to reproduce the issue on our end, zip the project and post us here. Please remove database (SQL server) dependencies and use dynamic data sets/ datatables in your codes, so we could evaluate your issue precisely to figure the issue out (if found).

Thank you.