Spreadsheet::BasicReadNamedCol Methods to easily read data from spreadsheets
Download

Spreadsheet::BasicReadNamedCol Ranking & Summary

Spreadsheet::BasicReadNamedCol Tags

Perl module perl class read spreadsheets spreadsheets

Spreadsheet::BasicReadNamedCol Description

Methods to easily read data from spreadsheets Spreadsheet::BasicReadNamedCol is a Perl module with methods to easily read data from spreadsheets with columns in the order you want based on the names of the column headings.Provides methods for simple reading of a Excel spreadsheet, where the columns are returned in the order defined.Assumes a specific format of the spreadsheet where the first row of data defined the names of the columns.SYNOPSIS use Spreadsheet::BasicReadNamedCol; my $xlsFileName = 'Excel Price Sheet 021203.xls'; my @columnHeadings = ( 'Supplier Part Number', 'Customer Price', 'Currency Code', 'Price UOM', 'Short Description', 'Long Description', ); my $ss = new Spreadsheet::BasicReadNamedCol($xlsFileName) || die "Could not open '$xlsFileName': $!"; $ss->setColumns(@columnHeadings); # Print each row of the spreadsheet in the order defined in # the columnHeadings array my $row = 0; while (my $data = $ss->getNextRow()) { $row++; print join('|', $row, @$data), " "; } Requirements: · Perl

Spreadsheet::BasicReadNamedCol Related Software