The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Spreadsheet::Read - Meta-Wrapper for reading spreadsheet data

SYNOPSIS

  use Spreadsheet::Read;
  my $ref = ReadData ("file.xls");

DESCRIPTION

Spreadsheet::Read offers a uniformed wrapper to Spreadsheet::ParseExcel and Spreadheet::ReadSXC to give the end-user a single point of view to various types of spreadsheets and deal with these in a transparent way.

For more thorough documentation please refer to the perl documentation in the module in pod format, or

  $ man Spreadsheet::Read

after installation.

INSTALLATION

  $ perl Makefile.PL
  $ make
  $ make test
  $ make install

If the make test warns you in the xls tests, read the message and apply the generated patch. Spreadsheet::ParseExcel has a small bug in the parsing of the default format regarding UTF-8.

This module requires perl-5.8.x or newer. It might still work under perl-5.6.x, but only if Encode is also available.

Recent changes can be (re)viewed in the public GIT repository at https://github.com/Tux/Spreadsheet-Read

Feel free to clone your own copy:

 $ git clone https://github.com/Tux/Spreadsheet-Read Spreadsheet-Read

or get it as a tgz:

 $ wget --output-document=Spreadsheet-Read-git.tgz \
           'https://github.com/Tux/Spreadsheet-Read/archive/master.tar.gz'

TODO

  * Make tests for examples/xlscat
  * Support Parsers native module options
  * Check if Tk is installed before asking if ss2tk is wanted
  * Test diagnostics output
  * Make clip skip empty sheets
  * Support Data::XLSX::Parser ?

AUTHOR

H.Merijn Brand, <h.m.brand@xs4all.nl>

COPYRIGHT AND LICENSE

Copyright (C) 2005-2016 H.Merijn Brand

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.