Change IXLCell number format from decimal point (.) to decimal comma (,) - c#

Viewed 246

So it's pretty simple..(at least I thought so...)

I'm trying to export some data to excel from my app and I can't find a solution how to change decimal point to decimal comma (this is also an European standard)

This is the code currently and numbers are written like 12,561.00

var cell = worksheet.Cell(i, 1);
cell.SetDataType(XLDataType.Number);
cell.Style.NumberFormat.SetFormat("#,##0.00");

I can't find solution for changing this code to show it like 12.561,00

I've tried obvious solution like this and similiar variations:

cell.Style.NumberFormat.SetFormat("#.##0,00");

Also I've tried these solutions from this link

I suppose I have to change format number globally in whole worksheet or workbook but I couldn't find any option that could work.

Thanks!

0 Answers
Related