This project is read-only.

write to .xls file silently fails

Apr 3 at 10:35 AM
Greetings,

I am able to read from an .xls file using HSSF's methods but when I try to write back to the file, the write silently fails with no error messages. I have unlocked the cells, but the sheets are still protected, and when I call the UnWriteProtectWorkbook() method, I get an index out of range error. I do not know whether the fact that the sheets are protected is the issue, especially given that the cells are all unlocked. I am using the SetCellValue method with a Convert.ToDouble cast inside it in C#. I have confirmed that I can manually update cells in Excel itself.

What are some of the most common causes of this type of silent error? Thank you!

Regards,

Theresa
Providence, Rhode Island