ANJAN PURKAYASTHA wrote: > > i have installed Spreadshee::ParseExcel to parse some large excel data > files. > > Here is the problem I'm facing. I need to parse data from columns M to P and > rows 10 to 43000. Now I know that there is a PrintArea method that can print > an area of a worksheet specified in (start row, start col, end row, end > col). However I'm having difficulty in specifying these parameters correctly > for the PrintArea method. I'm also not sure what the output is going to look > like.
I found both the code and the documentation of this module very difficult to understand. However I have an answer for you. If you read the documentation carefully it says "Workbook class has these properties:" before the list that includes PrintArea. What the author means by properties is hash elements, so you can access the array of print areas for the workbook by my $areas = $book->{PrintArea}; and the print areas for the first worksheet (did anyone else know an Excel worksheet could have multiple print areas?!) can be displayed by print "@$_\n" foreach @{$areas->[0]}; But it has a bug whereby the hash element sometimes doesn't appear at all. I sometimes had to ad a second sheet and give that a print area to make the attribute appear. However, if you remember that when the documentation refers to a 'property' it means a hash element it will make much more sense. HTH, Rob -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/