Revision history for Spreadsheet::Read

0.42 Wed 01 Jun 2011

• Add --html output option to xlscat
• Force CSV parser when in-sep is given
• Prefer Data::Peek over Data::Dumper if available

0.41 Wed 06 Oct 2010

• Spell-check
• Fixed requiring optional modules (RT#61928 - Roderick Schupp)

0.40 Wed 31 Mar 2010

• Default option for clip fixed (RT#56151 - Alan James)

0.39 Tue 16 Mar 2010

• Doc fix (RT#54507, Patrick Cronin)
• Upped Copyright notices to 2010
• Drop YAML version to 1.0

0.38 Tue 15 Dec 2009

• Add row () and cellrow ()
• Updated META.yml to meet most recent specs (optional_features = map)

0.37 Mon 09 Nov 2009

• IO streams improvements
• MANIFEST fix

0.36 Thu 06 Nov 2009

• Add strip option
• Spreadsheet::XLSX 0.12 still does not support attributes
• Require Text::CSV_XS-0.69 for CSV for auto-detection of \r
• New attribute "parser" to force format
• Allow CSV streams
• Allow SC streams
• Allow XLS streams

0.35 Wed 03 Jun 2009

• Add Test::NoWarnings, which is not run in AUTOMATED_TESTING
• Switched to Test::More using tests_done ()
• Text::CSV_XS requires 0.43 or up, as we use ->eof () still prefer a really new release, like 0.65, which is Test::NoWarnings safe
• Spreadsheet::XLSX 0.10 still does not support attributes
• Added -n to xlscat
• XLSX tests skip on feature, not on version

0.34 Tue 27 Jan 2009

• Spreadsheet::XLSX 0.09 still does not support attributes still think it is better to follow closely. 0.09 is much better than 0.08

0.33 Fri 23 Jan 2009

• A few Perl::Critic inspired changes
• Modified tests to prevent rounding errors (we were not checking for that)
• Added examples/ss-dups-tk.pl

0.32 Tue 06 Jan 2009

• Add basic support for M$ Excel 2007 using Spreadsheet::XLSX
• Test suite reports the parsers it found

0.31 Sun 04 Jan 2009

• Upped Copyright notices to 2009
• Detection of percentage type
• Even more reliable detection of Date types

0.30 Mon 22 Dec 2008

• Wrong e-mail in META.yml
• CSV files from a Mac, with \r as eol, would not parse

0.29 Sun 19 Oct 2008

• Make Read safer for files that do not match extension, like HTML in foo.xls
• YAML declared 1.4 (META.yml) instead of 1.1 (YAML)
• Bring Makefile.PL in sync with META.yml
• Recommend Text-CSV-0.56

0.28 Wed 04 Sep 2008

• More tests on date formats
• Declare Spreadsheet::ParseExcel::FmtDefault in META.yml
• Add 'size' from Excel font size
• Update docs about Excel quirks and CPAN links
• Reference to public git repo
• Some typo's

0.27 Sun 31 Aug 2008

• Fixed META.yml (the specs are inconsistent)
• Added --dtfmt to xlscat

0.26 Fri 29 Aug 2008

• Added examples/xls2csv
• Upped copyright to 2008 in examples
• Don't ask to install examples under automated testing
• die => croak
• Added tgzdist target
• Added encoding options to examples/xlscat
• Added date-type checks for SS:PE > 0.32

0.25 Wed 02 Jan 2008

• Spreadsheet-Read now under git
• Upped copyrights to 2008
• Added all prereq's to Makefile.PL, even core mods
• Tested under perl-5.10.0
• Text::CSV as of 1.00 is OK

0.24 Thu 05 Oct 2007

• -? and --help in utils moved to Getopt::Long
• Adjusted copyright notice in utils
• removed prototypes in utils
• next is illegal in do {} while (); (Johan Vromans) only happens with old Text::CSV_XS

0.23 Thu 21 Jun 2007

• Use IO::Scalar instead of File::Temp when installed Thanks to David Cantrell for making a OpenBSD test box available!
• use binmode () when opening files
• Also use 3-arg open in test files
• die if test files cannot be opene'ed

0.22 Mon 18 Jun 2007

• 0.21 should already support Text::CSV_PP 1.05 Tested Text::CSV_PP 1.05 on bleadperl.
• Better detection of (not) installed modules
• Module requires perl 5.6.x

0.21 Mon 18 Jun 2007

• Text::CSV_XS uses keep_meta_info instead of get_flags
• Removed always_quote from xlscat's CSV output

0.20 Thu 31 May 2007

• perlcritic OK
• CSV parsing now uses getline (), and auto-detects eol Assumes first line does not contain embedded eol. This implies that parsing CSV with embedded eol sequences is now safe.
• As I now also maintain Text::CSV_XS, I changed the references
• Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)

0.19 Fri 04 May 2007

• Could not retreive '0' fields from OpenOffice (Jim Kelly)

0.18 Fri 27 Apr 2007

• use strict in Makefile.PL
• Added test_cover make target
• Added "ods" for OpenOffice conversions
• Added color tests for ods (but SR::RS doesn't support that yet)
• Switched from \d to 0-9 in regexp
• Added more test files and tests (increase coverage)

0.17 Tue 04 Jul 2006

• xlscat new option: --ansii to (try to) use the ansi colors for fields
• Fixed a color attribute off-by-one error
• Added test cases (not yet complete)
• Added bold and underline

0.16 Tue 04 Jul 2006

• xlscat new option: --in-sep-char to force-define input sep-char for CSV
• More debug lines
• Parser name info in $ref->[0]
• SquirrelCalc now reports Spreadsheet::Read and its version for parser info
• Most of the attributes for Excel now implemented. Tested, but no test case

0.15 Wed 21 Jun 2006

• Small doc change from AnnoCPAN
• Sheets with undefined labels might cause havoc
• Clip now skips empty xls sheets (TODO: sxc)
• xlscat clips by default
• xlscat new options -d and --noclip
• xlscat usage () from -?/--help to STDOUT from fault to STDERR

0.14 Fri 20 Jan 2006

• maxrow and maxcol were swapped in csv sheets
• promoted internal debug flag to option
• small doc changes

0.13 Thu 04 Nov 2005

• Control attrib 'cells' was misinterpreted
• New option: clip, default is true if {cell} is selected, false otherwise Removes trailing lines and columns in each sheet that have no visible data
• new test t/11_call.t for checking options. Not complete yet
• Added test_cover target to Makefile.PL

0.12 Mon 31 Oct 2005

• Added ss2tk to examples

0.11 Wed 26 Oct 2005

• Allow ods (OpenOffice 2.0) for sxc
• include real ods test files and new test
• Check if sc.version is undef, not 0

0.10 Mon 19 Sep 2005

• More test coverage
• cr2cell () returns "" for illegal col/row values
• cell2cr () returns (0, 0) for illegal cell values
• rows () tests even better for valid reference pointer
• Renamed the test files

0.09 Sun 18 Sep 2005

• Added Test::Pod
• Added Test::Pod::Coverage
• Spreadsheet::ReadSXC 0.20 now required (too many tests fail on 0.12)
• Small changes to the docs
• More secure handling of false values
• Mention a bug in Spreadsheet::ParseExcel

0.08 Mon 22 Aug 2005

• Slightly changed the Synopsis

0.07 Wed 06 Jul 2005

• Added function rows ()
• Added function parses ()
• Made all modules optional
• Prepared for Spreadsheet::Perl
• Doc updates

0.06 Wed 22 Jun 2005

• Repaired error in label names in metadata for SXC

0.05 Thu 17 Jun 2005

• Spreadsheet::ReadSXC >= 0.20 supports sheet order
• Spreadsheet::ReadSXC has new data structure (we still support the old)
• Added "version" to the meta data for parser version
• More tests

0.04 Tue 14 Jun 2005

• Changed TODO
• Added options "rc", and "cell"
• Added CSV
• Added CSV options "sep", and "quote"
• Support xls from content
• Added basic support for SquirrelCalc format
• Updated pod
• xlscat -R option for row selection was a one-off
• xlscat now supports selecting fields with -F

0.03 Thu 19 May 2005

• Expanded xlscat to support -i for index
• Optionally install xlscat

0.02 Thu 19 May 2005

• Typoes in the doc
• Small change in organization so it actually installs

0.01 Thu 12 May 2005

• Initial CPAN version. A lot can still change