LXer: Reading Native Excel Files in Perl
 

Published at LXer:

In my last article for Linux Journal's web edition, I discussed a web-based program that queried an SQL database and output a native Excel file. That article was based on a program I wrote for a customer some time ago. Today, I'm going to write about doing the exact opposite; today's program will accept an Excel spreadsheet, collect data from it, and make additions to an SQL database. This program is also based on a program I'm writing for a customer. In fact, I wrote both programs for the same customer.

Read More...