Issues while exporting Datatable to Aspose Excel in c#

Aspose.Cells Product Family
1

HI ,

I am facing one issue while exporting DataTable to Aspose Excel .
I am using “workbook.Worksheets[0].Cells.ImportDataTable(DataTableName, true, “A1”)” method. While Exporting I found that in datatable my one of the column is having value as 5 but after exporting to Excel it is showing as '5 . I am not sure why it is happening . Hereby giving you screenshot for the same. And it happening with all columns.


2

Hi,


Thanks for providing us some details.

Could you create a sample console application (runnable), zip it and post it here to reproduce the issue on our end. We will check your issue soon. For datatable, you may create dynamic datatable in your code then import the table into the worksheet cells to show the issue on our end. Please do not involve any inter-dependencies or database and use only dynamic DataTable/DataSet so, we could evaluate your issue properly.

Thank you.