We trying update values from excel to word using Aspose.Cells but not getting exact values in Indian region. We fetch data from US region and try to update these values in Indian region.
localLang = "en-IN";
Thread.CurrentThread.CurrentCulture = new CultureInfo(localLang.Trim());
Aspose.Cells.Range range = worksheet.Cells.CreateRange(item.Range);
List<List<string>> strList = new List<List<string>>();
List<List<string>> formatList = new List<List<string>>();
int sRow = range.FirstRow;
for (int i = 0; i < range.RowCount; i++)
{
int sCol = range.FirstColumn;
if (!worksheet.Cells.Rows[sRow].IsHidden)
{
List<string> textStr = new List<string>();
List<string> formatStr = new List<string>();
for (int j = 0; j < range.ColumnCount; j++)
{
if (!worksheet.Cells.Columns[sCol].IsHidden)
{
Aspose.Cells.Cell cell = range[i, j];
textStr.Add(cell.DisplayStringValue);
formatStr.Add(cell.Type.ToString());
}
sCol++;
}
//rowList.Add(colArr);
strList.Add(textStr);
formatList.Add(formatStr);
}
sRow++;
}
Excel value : 11,23,45,678.90
US region : 112,345,678.90
IN region(in word) : 1123,45,678.90
Output i want : 11,23,45,678.90