Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Searching a string in excel sheets

by pme (Parson)
on Aug 10, 2015 at 10:24 UTC ( #1137998=note: print w/replies, xml ) Need Help??

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();
and then go along using 'for':
for my $col ( $col_min .. $col_max ) { my $cell = $worksheet->get_cell( $row, $col ); ... }

Replies are listed 'Best First'.
Re^2: Searching a string in excel sheets
by ravi45722 (Pilgrim) on Aug 10, 2015 at 10:32 UTC

    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 ???

      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?

        My file is .xlsx formated. Is it not supported by Spreadsheet::ParseExcel. What i have to do now ???

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1137998]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (7)
As of 2018-03-17 16:42 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (224 votes). Check out past polls.