http://qs321.pair.com?node_id=1187285


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?