Re^3: Scan cells in Excel active worksheet

[huck]

http://search.cpan.org/~dougw/Spreadsheet-ParseExcel-0.65/lib/Spreadsheet/ParseExcel/Workbook.pm

get_active_sheet()

Return the number of the active (open) worksheet (at the time the workbook was saved. May return undef.

http://cpansearch.perl.org/src/DOUGW/Spreadsheet-ParseExcel-0.65/lib/Spreadsheet/ParseExcel/Workbook.pm

sub get_active_sheet {
    my $workbook = shift;

    return $workbook->{ActiveSheet};
}

Maybe you can work from that for parseXLSX

[gauss76]

Many thanks huck for the answer, which works fine for .xls files with the code:

my $FileName = "Excel Test File 1.xls";

my $parser   = Spreadsheet::ParseExcel->new();

my $workbook   = $parser->parse($FileName);

my $Res1=get_active_sheet($workbook);

But I have no idea how to get it to work with xlsx files, which, currently fails if I try the following:

my $FileName = "Excel Test File 1A.xlsx";

my $parser   = Spreadsheet::ParseXLSX->new();

my $workbook   = $parser->parse($FileName);

my $Res1=get_active_sheet($workbook);

gauss76

[SuicideJunkie]

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?

[gauss76]

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