On Tue, 22 Jan 2008, Stéphane  VANDENBOGAERDE /vst .Y wrote:
What is the difference between a null cell and a blank cell ?

if row.getCell(num) returns null, there has never been data there

if row.getCell(num) returns a cell of type blank, then the file had data there, the data was removed, but excel is lazy and can't be bothered to remove the cell from the file, so just marks it as being blank


With ooxml, they've finally ditched the idea of blank cells (when you empty a cell, it really gets removed from the file), but they're a fun "feature" with the ole2 stuff :/

Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to