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 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279
|
Revision history for Spreadsheet::Read
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
|