Dots and comma

Aspose.Cells Product Family
1
Workbook wbk = new Workbook(excelFileStream);
wbk.CalculateFormula();

foreach (Worksheet wks in wbk.Worksheets)
{
if (wks.Cells.MaxDataRow > -1 && wks.Cells.MaxDataColumn > -1)
data.Tables.Add(wks.Cells.ExportDataTableAsString(0, 0, wks.Cells.MaxDataRow + 1, wks.Cells.MaxDataColumn + 1));
}
using the above when importing a sheet that contains decimal with '.' it will transform it to ','
i need to be able to import and have decimals with '.' eventhough it's already ',' we need it as '.'
2

Hi Zeinab,


Thank you for contacting Aspose support.

We have tried your presented scenario against a sample of our own, however, we are not able to observe the said problem while using the latest revision of the Aspose.Cells for .NET 8.6.3. Could you please give the latest version a try on your end? In case the problem persists, please share your input sample spreadsheet along with the cell/column/row reference that allowed you to observe the issue.