Hello,
Hi,
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 v7.0.2.2
C#
string filePath = @“F:\Shak-Data-RW\Downloads\Test.xlsx”;
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet.Cells[“A1”];
Debug.WriteLine(cell.StringValue);
$500.00
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.
Hi,
Please provide us your sample code to replicate this issue.