tags:

views:

46

answers:

1
Q: 

How to get dimesions of Excel worksheet in perl?

I need to find how many rows in worksheet have been defined. How can I do this?

+4  A: 

Use Spreadsheet::ParseExcel's row_range method.

hobbs  2010-08-19 05:26:20
What does Max and min? I didnt get. There should be only one value.
Shubham  2010-08-19 05:29:13
@Shubham, nobody forces you to put anything in row 1. `row_range` tells you both the first and last row that were actually used.
cjm  2010-08-19 05:33:04
Spreadsheet::ParseExcel only handles xls files; for xlsx, use Spreadsheet::XLSX
ysth  2010-08-19 06:01:00

related questions

Regex to replace Boolean with bool
How do I lock a file in Perl?
How do you use XML::Parser with Style => 'Objects'
Parsing XML Elements & Attributes with Perl
Regex to match all HTML tags except <p> and </p>
Best way to extract data from a FileMaker Pro database in a script?
What's the fastest way to determine a full URL from a relative URL (given a base URL).
Why can't I connect to my CAS server with Perl's AuthCAS?
Why can't I fetch wikipedia pages with LWP::Simple?
How do I perform a Perl substitution on a string while keeping the original?
How do I read in the contents of a directory in Perl?
How can Perl's system() print the command that it's running?
How can I test STDIN without blocking in Perl?
How do I tell if a variable has a numeric value in Perl?
Why doesn't my Perl map return anything?
How can I determine the type of a blessed reference in Perl?
Parsing attributes with regex in Perl
How do you retrieve selected text using Regex in C#?
Why does the Perl conditional operator not do what I expect?
Class::DBI-like library for php?
How do you create objects in Perl?
How do I remove duplicate items from an array in Perl?
Is The Perl Journal available online?
Can you force either a scalar or array ref to be an array in Perl?
What's the safest way to iterate through the keys of a Perl hash?