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:
Will $workbook->{SelectedSheet} work do the trick?my ($node) = $files->{workbook}->find_nodes('//s:workbookView'); my $selected = $node ? $node->att('activeTab') : undef; $workbook->{SelectedSheet} = defined($selected) ? 0+$selected : 0;
In Section
Seekers of Perl Wisdom