Hi,
I am using aspose.cells to generate CSV. The generated file does not open according to the user’s locale like in the case of Excel files is there a way to achieve this?
string FileName = @"C:\Users\Ankita\Downloads\input.xlsx";
string destFileName = @"C:\Users\Ankita\Downloads\outputaspose.csv";
List<string> LstReportObject = new List<string>();
LstReportObject.Add("Spend (EUR)");
// //Load your source workbook
Workbook workbook1 = new Workbook(FileName);
MemoryStream msFormatting = new MemoryStream();
workbook1.Save(msFormatting, SaveFormat.Xlsx);
Workbook workbook = new Workbook(msFormatting);
Worksheet ws = workbook.Worksheets[0];
// //ws.Cells[0,0].Value = "SEP= ";
// //0-byte array
TxtSaveOptions opts = new TxtSaveOptions();
opts.Encoding = Encoding.Unicode;
// opts.QuoteType = TxtValueQuoteType.Always;
opts.Separator = ',';
byte[] workbookData = new byte[0];
string[] columnName = new string[2];
string[] columnHeader = new string[2];
for (int i = 0; i < 2; i++)
{
columnName[i] = CellsHelper.ColumnIndexToName(i) + 4;
Cell cell = ws.Cells[columnName[i]];
columnHeader[i] = cell.Value.ToString();
}
foreach (var item in LstReportObject)
{
for (int i = 0; i < columnHeader.Length; i++)
{
if (columnHeader[i] == item)
{
if (item == "Spend (EUR)")
{
StyleFlag NumberFlag = new StyleFlag();
NumberFlag.NumberFormat = true;
Style NumberStyle = workbook.CreateStyle();
NumberStyle.Custom = "€#,##0.00";
ws.Cells.Columns[i].ApplyStyle(NumberStyle, NumberFlag);
}
break;
}
}
}
workbook.Save(destFileName,SaveFormat.CSV);
}
}
}
excelaspose2.zip (8.3 KB)