Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^5: Scan cells in Excel active worksheet

by SuicideJunkie (Vicar)
on Apr 06, 2017 at 13:47 UTC ( #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 (Beadle) 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
Node Status?
node history
Node Type: note [id://1187285]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2021-03-02 08:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favorite kind of desktop background is:











    Results (41 votes). Check out past polls.

    Notices?