I figured out how to generate Excel spreadsheets that open with newer versions of Excel, but it turns out many clients are using old versions of Excel. So I need to figure out how to generate old Excel files.
I used this to generate the files: http://en.wikipedia.org/wiki/Microsoft_Excel#XML_Spreadsheet
I don't need anything too complex, I just need to insert simple rows and columns. I can't find anything that shows me the old format though (I'm hoping it's at least something human-readable). I'm not even entirely sure which versions of Excel they are using. Is there some way I can generate an Excel document that will work for older versions?
I'd prefer if there was something that let me generate the file myself, but a library would be fine too. I'm using JS and Node, and all I can find is node-excel, which claims to have the first version done in March, and I assume will have the same problem as the simple program I wrote (not working with versions of Excel prior to 2002).
Thanks for reading.