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]
