We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How do i get the currency code form the aspose cells java for a cell?

I would like to get the currency code from my workbook for a particular cell. The type can be anything from $, ,etc and I would like to map it to USD,EUR,etc respectively. Is it possible with aspose cells java?


Thanks for your query.

Well, to get the custom formatting string set for a cell, you may use Style.getCustom() method (Style.setCustom() is used to apply your desired custom formatting to a cell), see the document for your reference:

Furthermore, you can also use Cell.getStringValue() to get the complete formatted value of the cell and then use your own JAVA code to evaluate/ check the currency symbol and map it accordingly for your needs.

Thank you.