Data::TableReader::Decoder::Spreadsheet - Base class for implementing spreadsheet decoders
version 0.014
This is a base class for any file format that exposes a spreadsheet API compatible with Spreadsheet::ParseExcel.
See attributes from parent class: Data::TableReader::Decoder.
This is an instance of Spreadsheet::ParseExcel, Spreadsheet::ParseXLSX, or Spreadsheet::XLSX (which all happen to have the same API). Subclasses can lazy-build this from the file_handle.
file_handle
This is either a sheet name, a regex for matching a sheet name, or a parser's worksheet object. It is also optional; if not set, all sheets will be iterated.
An optional object that is passed to Excel parsers Spreadsheet::ParseXLSX and Spreadsheet::ParseExcel. It governs how raw data in cells is formatted into values depending on the type of the cell. The parsers create one of their own if none is provided, usually Spreadsheet::ParseExcel::FmtDefault.
Note that it does not work for Spreadsheet::XLSX, which hardcodes the formatter as Spreadsheet::XLSX::Fmt2007.
Michael Conrad <mike@nrdvana.net>
This software is copyright (c) 2024 by Michael Conrad.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install Data::TableReader, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Data::TableReader
CPAN shell
perl -MCPAN -e shell install Data::TableReader
For more information on module installation, please visit the detailed CPAN module installation guide.