....and I should have said that it is likely that something else is happening
with your workbooks/worksheets.
Can you post just a quick snippet of code to show how you are 'processing'
the cells you get from the worksheets please; something like;
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIter = sheet.rowIterator();
while(rowIter.hasNext()) {
Row row = rowIter.next();
Iterator<Cell> cellIter = row.cellIterator();
while(cellIter.hasNext()) {
Cell cell = cellIter.next();
..................
}
}
yehogold wrote:
>
> But if the TYPE_NUMERIC cell is empty, won't it still be a TYPE_NUMERIC
> cell?
>
>
> VK123 wrote:
>>
>> You can use TYPE_BLANK to check if the cell is empty.
>>
>> Regards,
>>
>> Vijayakumar Gowdaman
>>
>> Group Technology & Operations (GTO)
>> Global Markets
>> Deutsche Bank
>> off: 02075456250
>> Mob:07789773998
>>
>>
>>
>> yehogold <[email protected]>
>> 11/08/2009 19:35
>> Please respond to
>> "POI Users List" <[email protected]>
>>
>>
>> To
>> [email protected]
>> cc
>>
>> Subject
>> The difference between a blank TYPE_NUMERIC cell and a TYPE_NUMERIC cell
>> with 0.
>>
>>
>>
>>
>>
>>
>>
>> Hi.
>>
>> I'm trying to test if a specific cell is empty. For TYPE_STRING cells, I
>> can get the cellStringValue and check it against an empty string.
>> getNumericValue(), returns '0' when the cell is empty, making it
>> impossible
>> to differentiate between a truly empty TYPE_NUMERIC cell and one that
>> contains '0'.
>>
>> How can a I check if a cell is truly empty?
>>
>> Thank you in advance for all your help.
>> --
>> View this message in context:
>> http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24923291.html
>>
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>>
>>
>>
>> ---
>>
>> This e-mail may contain confidential and/or privileged information. If
>> you are not the intended recipient (or have received this e-mail in
>> error) please notify the sender immediately and delete this e-mail. Any
>> unauthorized copying, disclosure or distribution of the material in this
>> e-mail is strictly forbidden.
>>
>> Please refer to http://www.db.com/en/content/eu_disclosures.htm for
>> additional EU corporate and regulatory disclosures.
>>
>
>
--
View this message in context:
http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24955534.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
