Re^5: Scan cells in Excel active worksheet

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;
[download]

Will $workbook->{SelectedSheet} work do the trick?

Comment on Re^5: Scan cells in Excel active worksheet Select or Download Code

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	[reply]

In Section Seekers of Perl Wisdom