A B 1 Number Name 2 1 Fred 3 15 Barney 4 27 Homer #### #! perl use strict; use warnings; use Spreadsheet::XLSX; use Data::Dump; my $excel = Spreadsheet::XLSX->new('xyz.xlsx'); if (!defined $excel) { die "Error: " . $excel->error() . "\n"; } print "Read with Spreadsheet::XSLX\n"; dd $excel; #### 21:43 >perl 1017_SoPW.pl Read with Spreadsheet::XSLX bless({ Flg1904 => 0, FmtClass => bless({}, "Spreadsheet::XLSX::Fmt2007"), SheetCount => 1, Worksheet => [ bless({ Cells => [ [ bless({ _Value => "Number", Format => "", Type => "Text", Val => "Number" }, "Spreadsheet::ParseExcel::Cell"), bless({ _Value => "Name", Format => "", Type => "Text", Val => "Name" }, "Spreadsheet::ParseExcel::Cell"), ], [ bless({ _Value => 1, Format => "", Type => "Numeric", Val => 1 }, "Spreadsheet::ParseExcel::Cell"), bless({ _Value => "Fred", Format => "", Type => "Text", Val => "Fred" }, "Spreadsheet::ParseExcel::Cell"), ], [ bless({ _Value => 15, Format => "", Type=> "Numeric", Val => 15 }, "Spreadsheet::ParseExcel::Cell"), bless({ _Value => "Barney", Format => "", Type => "Text", Val => "Barney" }, "Spreadsheet::ParseExcel::Cell"), ], [ bless({ _Value => 27, Format => "", Type=> "Numeric", Val => 27 }, "Spreadsheet::ParseExcel::Cell"), bless({ _Value => "Homer", Format => "",Type => "Text", Val => "Homer" }, "Spreadsheet::ParseExcel::Cell"), ], ], DefColWidth => 8.43, MaxCol => 1, MaxRow => 3, MinCol => 0, MinRow => 0, Name => "Paper.1", path => "worksheets/sheet1.xml", }, "Spreadsheet::ParseExcel::Worksheet"), ], }, "Spreadsheet::ParseExcel::Workbook") 21:43 >