1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
=head1 NAME
Spreadsheet::Read - Meta-Wrapper for reading spreadsheet data
=head1 SYNOPSIS
use Spreadsheet::Read;
my $ref = ReadData ("file.xls");
=head1 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.
=head1 INSTALLATION
$ perl Makefile.PL
$ make
$ make test
$ make install
If the C<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.1 or newer. It might still work under
perl-5.8.0 or perl-5.6.x, but only if Encode is also available. The
code might need some minor changes.
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'
=head1 TOOLS
Installing this module will optionally (default is yes) also install some
useful tools that use Spreadsheet::Read. At least two are know to cause a
possible name clash:
* xls2csv also exists as https://metacpan.org/release/KEN/xls2csv-1.06
Mine existed before that script, and this version dates from 2005
* ssdiff also exists in the gnumeric package with similar functionality
=head1 TODO
* Make tests for scripts/xlscat
* Support Parsers native module options
* Check if Tk is installed before asking if ss2tk is wanted
* Test diagnostics output
* Support Spreadsheet::Perl
* Support Data::XLSX::Parser
* Steal options from other CSV/Spreadsheet tools to implement in
xlscat and xlsgrep
=head1 AUTHOR
H.Merijn Brand <perl5@tux.freedom.nl>
=head1 COPYRIGHT AND LICENSE
Copyright (C) 2005-2025 H.Merijn Brand
This library is free software; you can redistribute it and/or modify
it under the same terms as Perl itself.
=cut
|
