in reply to Using perl to control spreadsheets

It's good that you've made this realisation, and I wish you luck on your way forward. But maybe you should even go one step further and, instead of doing spreadsheet programming, use a proper database as your backend data storage, and only use spreadsheets as your input/output/report format.

This obviously depends on what exactly you're doing, but I have found that a lot of the things people do with spreadsheets are actually better and easier to do if you're not tied to the simple grid table-format and have a relational database as your data store. Moving from one concept to the other can be a real eye-opener as well. Just a thought.


Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -- Brian W. Kernighan