| 1 |
=head1 NAME |
| 2 |
|
| 3 |
Spreadsheet::Read - Meta-Wrapper for reading spreadsheet data |
| 4 |
|
| 5 |
=head1 SYNOPSIS |
| 6 |
|
| 7 |
use Spreadsheet::Read; |
| 8 |
my $ref = ReadData ("file.xls"); |
| 9 |
|
| 10 |
=head1 DESCRIPTION |
| 11 |
|
| 12 |
Spreadsheet::Read offers a uniformed wrapper to Spreadsheet::ParseExcel |
| 13 |
and Spreadheet::ReadSXC to give the end-user a single point of view to |
| 14 |
various types of spreadsheets and deal with these in a transparent way. |
| 15 |
|
| 16 |
For more thorough documentation please refer to the perl documentation |
| 17 |
in the module in pod format, or |
| 18 |
|
| 19 |
$ man Spreadsheet::Read |
| 20 |
|
| 21 |
after installation. |
| 22 |
|
| 23 |
=head1 INSTALLATION |
| 24 |
|
| 25 |
$ perl Makefile.PL |
| 26 |
$ make |
| 27 |
$ make test |
| 28 |
$ make install |
| 29 |
|
| 30 |
If the C<make test> warns you in the xls tests, read the message and |
| 31 |
apply the generated patch. Spreadsheet::ParseExcel has a small bug in |
| 32 |
the parsing of the default format regarding UTF-8. |
| 33 |
|
| 34 |
This module requires perl-5.8.1 or newer. It might still work under |
| 35 |
perl-5.8.0 or perl-5.6.x, but only if Encode is also available. The |
| 36 |
code might need some minor changes. |
| 37 |
|
| 38 |
Recent changes can be (re)viewed in the public GIT repository at |
| 39 |
https://github.com/Tux/Spreadsheet-Read |
| 40 |
|
| 41 |
Feel free to clone your own copy: |
| 42 |
|
| 43 |
$ git clone https://github.com/Tux/Spreadsheet-Read Spreadsheet-Read |
| 44 |
|
| 45 |
or get it as a tgz: |
| 46 |
|
| 47 |
$ wget --output-document=Spreadsheet-Read-git.tgz \ |
| 48 |
'https://github.com/Tux/Spreadsheet-Read/archive/master.tar.gz' |
| 49 |
|
| 50 |
=head1 TOOLS |
| 51 |
|
| 52 |
Installing this module will optionally (default is yes) also install some |
| 53 |
useful tools that use Spreadsheet::Read. At least two are know to cause a |
| 54 |
possible name clash: |
| 55 |
|
| 56 |
* xls2csv also exists as https://metacpan.org/release/KEN/xls2csv-1.06 |
| 57 |
Mine existed before that script, and this version dates from 2005 |
| 58 |
* ssdiff also exists in the gnumeric package with similar functionality |
| 59 |
|
| 60 |
=head1 TODO |
| 61 |
|
| 62 |
* Make tests for scripts/xlscat |
| 63 |
* Support Parsers native module options |
| 64 |
* Check if Tk is installed before asking if ss2tk is wanted |
| 65 |
* Test diagnostics output |
| 66 |
* Support Spreadsheet::Perl |
| 67 |
* Support Data::XLSX::Parser |
| 68 |
* Steal options from other CSV/Spreadsheet tools to implement in |
| 69 |
xlscat and xlsgrep |
| 70 |
|
| 71 |
=head1 AUTHOR |
| 72 |
|
| 73 |
H.Merijn Brand <[email protected]> |
| 74 |
|
| 75 |
=head1 COPYRIGHT AND LICENSE |
| 76 |
|
| 77 |
Copyright (C) 2005-2025 H.Merijn Brand |
| 78 |
|
| 79 |
This library is free software; you can redistribute it and/or modify |
| 80 |
it under the same terms as Perl itself. |
| 81 |
|
| 82 |
=cut |