What if your boss demands a new version of a spreadsheet, with fresh data, every day? Should you enter them manually? No, if your data have a fixed structure and the spreadsheet can be in OpenDocument format (ODF)! If that's the case, it only takes a bit of shell and Perl scripting to generate automatically a new spreadsheet whenever the raw data change.
Full story »
