set Cell Format to Euro €

[Sintia]

Hi,

i have to format a cell in euro format, this means that the values must be . for thousand separator and , for decimal,
like: € 100.542,22

How i can do that?

thanks

[Gary.zhang]

Hello,

Thanks for your inquiry.
Our product is only able to set the cell format in invariant Culture. The following code is for your reference.

Code: Select all

CultureInfo cc = Thread.CurrentThread.CurrentCulture;
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
Workbook book = new Workbook();
Worksheet sheet = book.CreateEmptySheet("format");
sheet.Range["A1"].Value = "100542.22";
sheet.Range["A1"].NumberFormat = "€ #,##0.00";
book.SaveToFile("FormatCell.xlsx", ExcelVersion.Version2010);
Thread.CurrentThread.CurrentCulture = cc;


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Has the issue been resolved? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.
Thanks,
Gary
E-iceblue support team

[Sintia]

Yes thanks a lot soo much,
its working great

[burning.liu]

Hello Sintia,

Please feel free to contact us if you have any questions.