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

Aspose.Cells Product Family
1

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?

2

Hi,


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.