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!
Providence, Rhode Island