Data read wrongly using latest Aspose version

Aspose.Cells Product Family
1

Hi,


I am using Aspose.Cell 7.3.0.3 version and when I am trying to read data from excel sheet having negative value, in some cases it is read as positive integer. Issue not seen with older 7.2.1.9 version.

Sample Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Aspose.Cells;
using System.Data;

namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook(“C:/Book1.xlsx”);
Aspose.Cells.Cells cells = workbook.Worksheets[0].Cells;
DataTable dataTable = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);

}
}
}

Sample Excel sheet is attached with the mail.

Output screen shot is also attached with the mail.

2

Hi,


Please use ExportDataTable method instead. e.g

Workbook workbook = new Workbook(“e:\test2\Book1.xlsx”);
Aspose.Cells.Cells cells = workbook.Worksheets[0].Cells;
DataTable dataTable = cells.ExportDataTable(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);

Worksheet sheet = workbook.Worksheets[workbook.Worksheets.Add()];
sheet.Cells.ImportDataTable(dataTable, true, “A1”);
workbook.Save(“e:\test2\32outBook1.xlsx”);


Thank you.