• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..03-May-2022-

examples/H26-Feb-2021-285246

files/H03-May-2022-354339

scripts/H26-Feb-2021-1,178978

t/H26-Feb-2021-5,1404,086

CONTRIBUTING.mdH A D29-Aug-20191.3 KiB3725

ChangesH A D26-Feb-202117.6 KiB488404

MANIFESTH A D26-Feb-20211.9 KiB126125

META.jsonH A D26-Feb-20214.2 KiB155154

META.ymlH A D26-Feb-20211.6 KiB6564

Makefile.PLH A D01-Jan-20215.2 KiB166142

READMEH A D01-Jan-20212.2 KiB8253

Read.pmH A D26-Feb-202179.5 KiB2,6441,235

cpanfileH A D26-Feb-20211.9 KiB6448

README

1=head1 NAME
2
3Spreadsheet::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
12Spreadsheet::Read offers a uniformed wrapper to Spreadsheet::ParseExcel
13and Spreadheet::ReadSXC to give the end-user a single point of view to
14various types of spreadsheets and deal with these in a transparent way.
15
16For more thorough documentation please refer to the perl documentation
17in the module in pod format, or
18
19  $ man Spreadsheet::Read
20
21after installation.
22
23=head1 INSTALLATION
24
25  $ perl Makefile.PL
26  $ make
27  $ make test
28  $ make install
29
30If the C<make test> warns you in the xls tests, read the message and
31apply the generated patch. Spreadsheet::ParseExcel has a small bug in
32the parsing of the default format regarding UTF-8.
33
34This module requires perl-5.8.1 or newer. It might still work under
35perl-5.8.0 or perl-5.6.x, but only if Encode is also available. The
36code might need some minor changes.
37
38Recent changes can be (re)viewed in the public GIT repository at
39https://github.com/Tux/Spreadsheet-Read
40
41Feel free to clone your own copy:
42
43 $ git clone https://github.com/Tux/Spreadsheet-Read Spreadsheet-Read
44
45or 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
52Installing this module will optionally (default is yes) also install some
53useful tools that use Spreadsheet::Read. At least two are know to cause a
54possible 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  * Make clip skip empty sheets
67  * Support Spreadsheet::Perl
68  * Support Data::XLSX::Parser
69
70=head1 AUTHOR
71
72H.Merijn Brand <perl5@tux.freedom.nl>
73
74=head1 COPYRIGHT AND LICENSE
75
76Copyright (C) 2005-2021 H.Merijn Brand
77
78This library is free software; you can redistribute it and/or modify
79it under the same terms as Perl itself.
80
81=cut
82