I changed my code to simply test if the cell was of TYPE_BLANK and modified
the type of the cell when I changed its value later on in the code to
circumvent the need for it to retain its value when blank, just to be safe.
It seems to work just fine now.
Thank you very much for your help,
yehogold
MSB wrote:
>
> ....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.-tp24923291p24955842.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]
