Re: Extract column of excel

Also have a look at Text::CSV_XS.

J.C.

Comment on Re: Extract column of excel

Replies are listed 'Best First'.

Re^2: Extract column of excel
by MynameisAchint (Novice) on Jun 04, 2013 at 05:59 UTC

Hey Has anybody got a script for it , it would be really useful for me

by Anonymous Monk on Jun 04, 2013 at 08:21 UTC

Text::CSV

examples/csv2xls Script to onvert CSV files to M$Excel

examples/csv-check Script to check a CSV file/stream

examples/csvdiff Script to shoff diff between sorted CSV files

examples/parser-xs.pl Parse CSV stream, be forgiving on bad lines

[CSV hash ] CSV hash: Best way to match a hash with large CSV file; perl hash to CSV using Text::CSV_XS; Issue parsing CSV into hashes?; Veriable Length Array/Hash derived from CSV to populate an XML; extracting data from CSV files and making hash of hashes; Re^2: build hash from csv file; Encoding a hash in perl before saving it as a CSV file; hash from CSV-like structure; Read the csv file to a hash....; Parsing CSV into a hash; build hash from csv file; Converting a CSV list to a list of hashrefs naming the fields