in reply to Searching a string in excel sheets

As you can see in the 'synopsis' part of Spreadsheet::ParseExcel you can get the column range of a given worksheet using: 
my ( $col_min, $col_max ) = $worksheet->col_range();

[download]
and then go along using 'for': 
for my $col ( $col_min .. $col_max ) {

   my $cell = $worksheet->get_cell( $row, $col );
   ...
}

[download]

Replies are listed 'Best First'.
Re^2: Searching a string in excel sheets
by ravi45722 (Pilgrim) on Aug 10, 2015 at 10:32 UTC
    http://www.perlmonks.org/?node_id=1121108

    I saw that module and tried the example. It returns the same error which metioned in the above node.

    Error: No Excel data found in file.

    There someone suggested use Win32::OLE. We cant do this using Spreadsheet::ParseExcel ???

[reply]

      That error code means that the file you passed to your program was not in a format understood by Spreadsheet::ParseExcel. Maybe your file is not an .xls file?

[reply]
[d/l]
        My file is .xlsx formated. Is it not supported by Spreadsheet::ParseExcel. What i have to do now ???
[reply]

In Section Seekers of Perl Wisdom