in reply to Spreadsheet::ParseExcel::Simple, reading specific cells?
To get to a specific row you will have to repeatedly call next_row(). You cannot explicitly reference a column using Spreadsheet::ParseExcel::Simple so you will have to programmitically build up a column array using the data returned from the rows.#!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel::Simple; my $workbook = Spreadsheet::ParseExcel::Simple->read('example.xls +'); my $worksheet = ($workbook->sheets())[1]; while ($worksheet->has_data()) { my @data = $worksheet->next_row(); print "@data\n"; }
--
John.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Spreadsheet::ParseExcel::Simple
by Anonymous Monk on Jan 20, 2013 at 17:35 UTC |