I hate supporting Excel97.
I have a spreadsheet that has X number of worksheets. The gridline value for each sheet has been turned off and I need to turn them back on before ftp-ing the file off the server (we don’t have Excel on the server) and I cannot ask the recipient to turn them back on per my employer. I also cannot buy code to do this (must be open source).
Basically, I need to open a stream to an Excel file and turn the gridlines on per sheet. I found the following document outlining that file's binary format:
http://sc.openoffice.org/excelfileformat.pdf
It looks like I need to read for 023EH and then change the value at offset 1 from 0 to 1. But I never work with binary files so I’m lost as to what to do. I also would need to read the entire file for this (since there could be more than one sheet per file).
Can anyone show me how to do this? If so I would be immensely appreciative (I’ve been racking my brain over this one for weeks).
Thank you in advance. TRF