Spreadsheet::XLSX Perl class for reading MS Excel 2007 files
Download

Spreadsheet::XLSX Ranking & Summary

Spreadsheet::XLSX Tags

spreadsheet Perl module perl spreadsheet reader XLSX XLSX reader

Spreadsheet::XLSX Description

Perl class for reading MS Excel 2007 files Spreadsheet::XLSX is a Perl extension for reading MS Excel 2007 files.SYNOPSIS 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 ('test.xlsx', $converter); foreach my $sheet (@{$excel -> {Worksheet}}) { printf("Sheet: %s ", $sheet->{Name}); $sheet -> {MaxRow} ||= $sheet -> {MinRow}; foreach my $row ($sheet -> {MinRow} .. $sheet -> {MaxRow}) { $sheet -> {MaxCol} ||= $sheet -> {MinCol}; foreach my $col ($sheet -> {MinCol} .. $sheet -> {MaxCol}) { my $cell = $sheet -> {Cells} ; if ($cell) { printf("( %s , %s ) => %s ", $row, $col, $cell -> {Val}); } } } }This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format. It supports styles and many of Excel's quirks, but not all. It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet, and Cell. Requirements: · Perl

Spreadsheet::XLSX Related Software