Programmatically extract data from an Excel spreadsheet


Question

Is there a simple way, using some common Unix scripting language (Perl/Python/Ruby) or command line utility, to convert an Excel Spreadsheet file to CSV? Specifically, this one:

http://www.econ.yale.edu/~shiller/data/ie_data.xls

And specifically the third sheet of that spreadsheet (the first two being charts).

1
7
8/7/2009 8:13:54 AM

There is a really good Perl library for xls reading: Spreadsheet::ParseExcel.

14
8/7/2009 9:15:30 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon