OK, I explained badly!

The Excel file is saved to disk on the linux server.

I use the following commands to get acces to the Excel file

I use one of the above depending on whether the file is .xls or .xlsx. Then I use:

It's the next part that is causing the problem. currently I loop through all worksheets with

But I really only want to work with the active worksheet.

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

Maybe you can work from that for parseXLSX

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