setMissingCellPolicy

[adam s]

I've been struggling to get setCellValue() to insert some text to a few cells in an existing and somewhat messy spreadsheet and I believe I've pinned my issue down to how the rows are being read in. I believe that cells that are empty in the original spreadsheet are being converted to NULL and thus unavailable to be updated in setCellValue(). Odd thing is that some cells that appear as empty are being read in as NA, which doesn't limit my use of setCellValue.

Any guidance on how to use setMissingCellPolicy within the package would be great. 

Many thanks--