There is a lot of environmental settings missing in your question. As others already found: do not use Spreadsheet::XLSX, but Spreadsheet::ParseXLSX.

When I fetch your file, I can verify the reason to change the parser

use Spreadsheet::Read;
my $ss = Spreadsheet::Read->new ("pm1209625.xlsx", debug => 3);
[download]

→

$ perl pm1209625.pl
Opening XLSX pm1209625.xlsx using Spreadsheet::ParseXLSX-0.27
        4 sheets
        Sheet 2 'Cities' 215 x 1
        Sheet 3 'Categories' 22 x 1
        Sheet 4 'Items' 187 x 2
        Sheet 5 'VehicleTypes' 14 x 1

$ env SPREADSHEET_READ_XLSX=Spreadsheet::XLSX perl pm1209625.pl
Opening XLSX pm1209625.xlsx using Spreadsheet::XLSX-0.15
        0 sheets
[download]

A short digging revealed that the parser only accepts xml tags sheet, where your workbook has tags /x:workbook at that level (XLSX.pm line 53).

It is IMHO a lost cause to file a ticket.

Code from synopsis section of Spreadsheet::ParseXLSX (which itself further refers to Spreadsheet::ParseExcel) works OK with your file.

As to Spreadsheet::XLSX, there's strong opinion about it here:

Spreadsheet::XLSX

This module is dead and deprecated. It is buggy and unmaintained. Please use Spreadsheet::ParseXLSX instead.

Hello Arik123,

I download your excel file 'aveidotvalues-3.xlsx' for testing purposes and this is what I found using Spreadsheet::XLSX:

#!/usr/bin/perl
use strict;
use warnings;
use Data::Dumper;

use Text::Iconv;
my $converter = Text::Iconv -> new ("utf-8", "windows-1251");

# Text::Iconv is not really required.
# This can be any object with the convert method. Or nothing.

use Spreadsheet::XLSX;

my $excel = Spreadsheet::XLSX -> new ('aveidotvalues-3.xlsx', $convert
+er);

print Dumper $excel;

__END__

$ perl test.pl
$VAR1 = bless( {
                 'SheetCount' => 0,
                 'FmtClass' => bless( {}, 'Spreadsheet::XLSX::Fmt2007'
+ ),
                 'Flg1904' => 0,
                 'Worksheet' => []
               }, 'Spreadsheet::XLSX' );
[download]

I also test your excel file with Spreadsheet::Read and this is the output:

#!/usr/bin/perl
use strict;
use warnings;
use Data::Dumper;
use Spreadsheet::Read qw(ReadData);

my $book = ReadData ('aveidotvalues-3.xlsx');

print Dumper $book;

__END__

$ perl test.pl
$VAR1 = [
          {
            'parsers' => [
                           {
                             'version' => '0.15',
                             'type' => 'xlsx',
                             'parser' => 'Spreadsheet::XLSX'
                           }
                         ],
            'error' => undef,
            'sheet' => {},
            'version' => '0.15',
            'sheets' => 0,
            'type' => 'xlsx',
            'parser' => 'Spreadsheet::XLSX'
          }
        ];
[download]

I can not test any Windows spreadsheet modules because I am running a LinuxOS, but what I can see so far both modules they can not see your sheets. This is the reason that the data can not be populated. So what I would recommend, is either use a Perl module to produce your files or download Apache OpenOffice to create your spreadsheets. Remember openoffice is compatible with WindowsOS and also LinuxOS and so far all the files that I have populated it worked correctly with all the Perl modules.

Hope this helps, BR.

Maybe you can use Win32::OLE module.