Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Scan cells in Excel active worksheet

by SuicideJunkie (Vicar)
on Apr 03, 2017 at 14:57 UTC ( #1186836=note: print w/replies, xml ) Need Help??


in reply to Scan cells in Excel active worksheet

Well, you can't parse the excel file if it hasn't yet been saved to disk...

If you want to work with an opened file, then you would need to use excel APIs (See Win32::Ole) to control the application itself. Perhaps try running it through WINE?

  • Comment on Re: Scan cells in Excel active worksheet

Replies are listed 'Best First'.
Re^2: Scan cells in Excel active worksheet
by gauss76 (Beadle) on Apr 03, 2017 at 15:19 UTC

    OK, I explained badly!

    The Excel file is saved to disk on the linux server.

    I use the following commands to get acces to the Excel file

    $parser   = Spreadsheet::ParseExcel->new();

    $parser   = Spreadsheet::ParseXLSX->new();

    I use one of the above depending on whether the file is .xls or .xlsx. Then I use:

    my $workbook = $parser->parse($FileName);

    It's the next part that is causing the problem. currently I loop through all worksheets with

    for my $worksheet ( $workbook->worksheets() )

    But I really only want to work with the active worksheet.

    gauss76

        Many thanks huck for the answer, which works fine for .xls files with the code:

        my $FileName = "Excel Test File 1.xls";

        my $parser   = Spreadsheet::ParseExcel->new();

        my $workbook   = $parser->parse($FileName);

        my $Res1=get_active_sheet($workbook);

        But I have no idea how to get it to work with xlsx files, which, currently fails if I try the following:

        my $FileName = "Excel Test File 1A.xlsx";

        my $parser   = Spreadsheet::ParseXLSX->new();

        my $workbook   = $parser->parse($FileName);

        my $Res1=get_active_sheet($workbook);

        gauss76

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1186836]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2021-03-01 15:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favorite kind of desktop background is:











    Results (12 votes). Check out past polls.

    Notices?