Set Cell Value Currency

Set Cell value currency, how to

Same as in Excel, you can set a currency value with specifing these information:

-The value

-The format: Currency, Accounting, CurrencyRedNegative, CurrencyRedNegativeNoSign, CurrencyLeftSpace

-The name: Euro, UsDollar, BritishPound, ... and more ...

-The number of displayed decimal

Example:

// -62,00 € - the value is negative so it will displayed in red, the negative sign will be displayed
proc.SetCellValueCurrency(excelSheet, "B6", -62, CurrencyFormat.CurrencyRedNegative, CurrencyName.Euro, 2);

List of managed currencies

Euro,
UsDollar,
BritishPound,
SwissFranc,
JapaneseYen,
SouthKoreanWon,
AustralianDollar,
CanadianDollar,
ChineseYuan,
NewZealandDollar,
SingaporeDollar,
Bitcoin