Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Searching a string in excel sheets

by pme (Prior)
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
    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 ???

      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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2018-06-22 08:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?



    Results (122 votes). Check out past polls.

    Notices?