views:

46

answers:

1

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
What does Max and min? I didnt get. There should be only one value.
Shubham
@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
Spreadsheet::ParseExcel only handles xls files; for xlsx, use Spreadsheet::XLSX
ysth