in reply to extracting single column

Check out http://search.cpan.org/dist/excel2txt/
That script will convert each worksheet in an Excel spreadsheet to separate CSV text files. You can then parse each .csv and, split out the column you are looking for.