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

[smartbala11gmail]

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?

[Amjad_Sahi]

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:

http://www.aspose.com/docs/display/cellsjava/Setting+Display+Formats+of+Numbers+and+Dates

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.