I'm just getting to my mail but your method is unneccessary. createDataFormat on HssfWorkbook will return you a HSSFDataFormat object that knows how to lookup indexes, formats, and insert new ones. It works quite well and doesn't need to expose the underlying objects and records (thus allowing the developers to improve the underlying model with changing the user interface).
Shawn [EMAIL PROTECTED] wrote: __________ > Re: How to distinguish between different dates formats and decimals > For the benefit of all other users...here is what I > had asked in my email to Mr.Oliver and Mr. Laubach to > get their blessings on the solution below. The email > below had a reference to my earlier email also. > ======================================== > Hello, > Please correct me if I am wrong...here is how I am > planning to figure out the underlying cell type for > different dates and decimals (figuring out how many > decimal places it has). > > Since there is no way to get Workbook from > HSSFWorkbook, for now I am going to insert a accessor > method to get it. > > Once I get the dataFormatIndex..... > int cellType = theCell.getCellType(); > HSSFCellStyle cellStyle = theCell.getCellStyle(); > short dataFormatIndex = cellStyle.getDataFormat(); > > I will get the list of FormatRecord from Workbook > (workbook.formats) and search for those > dataFormatIndex which are not in the HSSFDataFormat. > > I have experimented with this, this seems to work! > Please let me know if I am correct in my approach. > Thanks for your help. > > __________________________________ > Do you Yahoo!? > Yahoo! Tax Center - File online by April 15th > http://taxes.yahoo.com/filing.html > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
