Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^5: Scan cells in Excel active worksheet

by SuicideJunkie (Vicar)
on Apr 06, 2017 at 13:47 UTC ( [id://1187285]=note: print w/replies, xml ) Need Help??


in reply to Re^4: Scan cells in Excel active worksheet
in thread Scan cells in Excel active worksheet

A quick peek through the source, and I spotted:

my ($node) = $files->{workbook}->find_nodes('//s:workbookView'); my $selected = $node ? $node->att('activeTab') : undef; $workbook->{SelectedSheet} = defined($selected) ? 0+$selected : 0;
Will $workbook->{SelectedSheet} work do the trick?

Replies are listed 'Best First'.
Re^6: Scan cells in Excel active worksheet
by gauss76 (Scribe) on Apr 07, 2017 at 08:29 UTC

    Fantastic!!

    Many thanks for everyone's help with this...Special thanks must go to SuicideJunkie.

    The solution will really help me with my project.

    gauss76

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (7)
As of 2024-03-29 09:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found