Please use Cell.StringValue instead of Cell.Value, because values like numbers, dates, currency etc are all stored as integers.
Please see the code below and its output. I have used the latest:
Aspose.Cells for .NET v188.8.131.52
string filePath = @“F:\Shak-Data-RW\Downloads\Test.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets;
Cell cell = worksheet.Cells[“A1”];
This happens also when i do this:
results = CurrentWorkBook.Worksheets.GetRangeByName(mappingField).ExportDataTableAsString();
Is there a work around for this scenario? Also was this a change to they way values are pulled in the latest release 7.0 + as rolling back to my production release the values work just fine in comparison to the first post.
Please provide us your sample code to replicate this issue.