Debian Codegraph @

Changes

raw
1 0.95 - 25 Jan 2026, H.Merijn Brand
2 * It's 2026
3
4 0.94 - 09 Dec 2025, H.Merijn Brand
5 * Add label2col ()
6 * $sheet->{attr} should always be there, might be empty (issue#56)
7 * Skip type tests when unsupported (issue#56)
8 * Skip merge tests when unsupported (issue#56)
9 * Update SECURITY.md
10
11 0.93 - 17 Mar 2025, H.Merijn Brand
12 * Add ranges and cellranges
13
14 0.92 - 06 Jan 2025, H.Merijn Brand
15 * Make strict_eol default to 1 for CSV when supported
16 * Show detected EOL for CSV in xlscat when known
17 * Add SECURITY.md
18 * It's 2025
19
20 0.91 - 27 Aug 2024, H.Merijn Brand
21 * Exclude OLE::Storage_Lite-0.21
22 * xlscat --head[=10], --tail[=10], --first=C
23 * Make (re)defining ->get_active_sheet safer
24 * Tested with perl-5.40
25 * xlscat --no-empty to skip empty columns too
26 * Spreadsheet::ParseExcel::FmtDefault might not be available
27
28 0.90 - 13 Feb 2024, H.Merijn Brand
29 * Consistent return value for parses ($type) on failure (issue#52)
30 * New options for xlscat (--no-empty, --clip=N)
31 * Support for hidden sheets
32
33 0.89 - 02 Jan 2024, H.Merijn Brand
34 * Auto-use BOM in CSV *files* with xlscat script
35 * Fix duplicate option letter (typo) (Erix)
36 * It's 2024
37
38 0.88 - 07 Nov 2023, H.Merijn Brand
39 * Guard $_ globbering from external bitrotted code
40 * Use recommended and suggested versions based on known CVEs
41 * Improve user feedback on failing xlsx2csv & xlscat
42 * Fix static docs for groff-1.24
43 * Basic support for Excel::ValueReader::XLSX (issue#50)
44 * Allow backend for parser option without version check
45
46 0.87 - 22 Feb 2023, H.Merijn Brand
47 * Change default #! to /usr/bin/perl (Tinita)
48 * Improve ->sheets (safer and docs)
49 * Update to Spreadsheet::ReadGnumeric 0.2 (attributes and small fixes)
50
51 0.86 - 07 Feb 2023, H.Merijn Brand
52 * Add Gnumeric support (Bob Rogers, THANKS!)
53 - work in progress, use with care, feedback welcome
54
55 0.85 - 04 Jan 2023, H.Merijn Brand
56 * Suggest the preferred parser if none found
57 * It's 2022
58 * xlscat --box and improvements for -L
59 * Add balloons to ss2tk buttons
60 * Fix typo in help (Erix)
61 * It's 2023
62
63 0.84 - 26 Feb 2021, H.Merijn Brand
64 * It's 2021
65 * Alias pivot to transpose (issue#36)
66 * Alias strip to trim (issue#36)
67 * Check for consistent return values of parses ()
68
69 0.83 - 21 Dec 2020, H.Merijn Brand
70 * Require ParseODS 0.26
71 * Add ::parsers to get list of supported formats
72 * Add --list to xlscat and xls2csv
73 * Update xls2csv to be identical to xlsx2csv
74 * ::parses ("") will return list of supported types
75 * Move installables from examples/ to scripts/
76 * Tested on FreeBSD-12.2-RELEASE with all supported backends
77 * Fix META issue for bugtracker
78
79 0.82 - 26 Sep 2020, H.Merijn Brand
80 * Move pod tests to xt (and do not distribute)
81 * Fix some links in the docs
82 * Add ".xlsm" to known XLSX file extensions
83 * Spreadsheet::ReadSXC has a new maintainer (Corion)
84 - support file handles
85 - suggest version 0.24 (0.22 causes fails)
86 * First attempt in supporting Spreadsheet::ParseODS (alpha code)
87 - version 0.25 should now pass the limited tests
88 - thanks to Corion for making this happen!
89 * It's 2020
90 * Fallback to Pod::Text if nroff not available in tools
91 * Extended support for merged cells with merge option
92 - Added $sheet->merged_from ("C2")
93 * Add --no-nl[=x] to xlscat
94 * xlscat: Align-right more numerics on -L (was only positive integers)
95 * xlsx2csv -Z : generate a ZIP file with a CSV for every sheet
96 * Doc fix (issue#33)
97
98 0.81 - 25 Aug 2019, H.Merijn Brand
99 * It's 2019
100 * Allow -c + --sep in xlscat
101 * Add --sep= to xls2csv for -A
102 * Add xlsx2csv to distribution (xlsx2csv has -A)
103 * Add -J s / --join str to xlsx2csv
104 * Add cpanfile
105 * Add explicit documentation about formatted vs unformatted
106 * Improve ->new behavior
107 * Auto-detect fallback for CSV now includes '|' for sep_char (PR#26)
108
109 0.80 - 31 Dec 2018, H.Merijn Brand
110 * Raise Spreadsheet::ParseXLSX minimum version to 0.24
111 * Improve docs on attributes
112 * Add attribute accessors
113
114 0.79 - 29 Aug 2018, H.Merijn Brand
115 * Environmant control hardening
116 * ReadData () docs (opening from scalar ref: issue#21)
117 * Check for XLSX content on opening from plain scalar content
118 * Fix typo in ss-dup-tk.pl (PRC, Branislav Zahradnik)
119 * Allow source from command line option in xls2csv (PRC, Branislav Zahradnik)
120 * Allow --in-sep=tab in xlscat/xlsgrep
121 * Add --hash to xlscat/xlsgrep
122 * Help and usage for examples/xls2csv (PR#23)
123
124 0.78 - 29 Jan 2018, H.Merijn Brand
125 * Spreadsheet::ParseExcel supports the active flag as of version 0.61
126 * Fix typo in docs (SPROUT, RT#124214)
127
128 0.77 - 22 Jan 2018, H.Merijn Brand
129 * Note possible name clashes with example/tool files
130 * Clipping and stripping more efficient
131
132 0.76 - 01 Jan 2018, H.Merijn Brand
133 * Allow streaming in xlscat
134 * Add --dump to xlscat
135 * Add error for opening ODS/SXC from reference
136 * It's 2018
137
138 0.75 - 09 Nov 2017, H.Merijn Brand
139 * Windows does not like an exec with arguments that have spaces (PR#15)
140 Three fixes by Andrew Gregory <[email protected]>). Thanks!
141 * Fix column clipping
142 * Manually generate cells to delete when clipping
143 * Skip cell deletion if they were never generated
144 * File names cannot have \0 in newer perls
145
146 0.74 - 27 Aug 2017, H.Merijn Brand
147 * Re-enable opening files with bad characters in the filename (issue#14)
148
149 0.73 - 30 Jul 2017, H.Merijn Brand
150 * Spreadsheet::XLSX::Reader::LibXML support completely dropped
151 * New options for ss2tk (font specs and SS labels)
152 * Safer xls2csv option parsing/passing
153 * Pass unknown command-line options to the parser
154 * Fix ReadData ("a,b,c\n1,2,3\n", parser => "csv")
155 * Drop 5.8.0 support. 5.8.1 is now minimum
156
157 0.72 - 25 May 2017, H.Merijn Brand
158 * get_active_sheet is only available as of Spreadsheet::ParseExcel 0.61
159 * Support password protected spreadsheets (implementation just for Excel)
160 * Do not warn on undefined labels (xlscat)
161
162 0.71 - 13 May 2017, H.Merijn Brand
163 * Use -w as intended
164 * Add option pivot
165 * No trailing spaces on xlscat -L
166 * Lexicalize code snippet (issue#12)
167 * Add attr method
168 * Remove special chars from worksheet name component (Windows, PR#13)
169 * Add refresh to ss2tk / csv2tk
170 * Add shortcut for UTF-8 output to xlscat
171 * Upgrade recommended modules to required for cpancover
172
173 0.70 - 02 Mar 2017, H.Merijn Brand
174 * Add label functionality to ::Sheet
175 * Add ->column and ->cellcolumn for ::Sheet
176 * Add col2label sub/method
177 * Sanitize xls2csv export filenames
178 * Fix sorting in xlscat for un-aligned columns
179 * It's 2017
180 * Be overly verbose about maxrow and maxcol being 1-based (RT#120476)
181
182 0.69 - 02 Dec 2016, H.Merijn Brand
183 * Several OO fixes, more tests, more docs
184
185 0.68 - 29 Nov 2016, H.Merijn Brand
186 * List non-core modules/version used on very verbose in xlscat
187 * Option to export all sheets in a spreadsheet to CSV (UTF-8 only)
188 * Add OO interface
189 * Feature: add new spreadsheets to existing book (even of different types)
190
191 0.67 - 17 Jun 2016, H.Merijn Brand
192 * CPANTESTERS showed that some versions really messed op numeric/percentage
193
194 0.66 - 16 Jun 2016, H.Merijn Brand
195 * Remove Spreadsheet::XLSX::Reader::LibXML test files from distribution
196 * Allow old versions of Spreadsheet::ParseXLSX to "fail" on percentage tests
197
198 0.65 - 15 Jun 2016, H.Merijn Brand
199 * Test with perl-5.24.0
200 * Show parser-version used under debug
201 * No more Spreadsheet::XLSX::Reader::LibXML
202 * Cells will inherit hidden state from hidden rows and columns
203 * Require 5.8.0 as 5.6.x does not include required Encode
204
205 0.64 - 22 Apr 2016, H.Merijn Brand
206 * It's 2016
207 * Allow inconsistent Spreadsheet::XLSX releases on Debian (tests)
208 * Decode utf-16be entries in Excel when appropriate
209 * Two examples in xlscat
210
211 0.63 - 10 Oct 2015, H.Merijn Brand
212 * Guard against negative MinRow in XLSX
213 * Documentation updated
214 * Support Spreadsheet::XLSX::Reader::LibXML disabled on author request
215 * Fix warning in utilities
216 * Check minimum parser version for pre-selected parser
217
218 0.62 - 16 Aug 2015, H.Merijn Brand
219 * Fix documentation structure
220 * Test all supported parsers (not just the preferred one)
221 * Basic support for Spreadsheet::XLSX::Reader::LibXML (work in progress)
222 * Copy example file if link fails (Alan Berndt)
223 * Add a contributing guide
224
225 0.61 - 13 Jun 2015, H.Merijn Brand
226 * Discourage Spreadsheet::XLSX
227 * A space is not an empty field in XLS
228 * Strip the correct selection (RT#105197)
229
230 0.60 - 30 Mar 2015, H.Merijn Brand
231 * No merged cell support in Spreadsheet::XLSX
232
233 0.59 - 26 Mar 2015, H.Merijn Brand
234 * Minimal support (+ docs) for merged cells
235 * Make parser errors report at one level up
236 * Don't select non-existing columns in xlscat
237
238 0.58 - 11 Feb 2015, H.Merijn Brand
239 * Remove perl recommendation from META as it breaks cpan clients
240 * Move sort instruction to correct place in xlscat's help
241
242 0.57 - 08 Feb 2015, H.Merijn Brand
243 * Moved project to github
244 * Add --sort to xlscat
245 * Clip before conversion
246 * Removed an unneeded localizing of $/ (related to p5 RT#123218)
247
248 0.56 - 05 Jan 2015, H.Merijn Brand
249 * printf does not play nice with encoding (related to RT#98436)
250 * default output UTF-8 if whole line is UTF-8
251
252 0.55 - 01 Jan 2015, H.Merijn Brand
253 * Mention Spreadsheet::CSV in documentation
254 * Add ssdiff to examples
255 * Amend xlscat -n to also number in HTML
256 * Updated copyright to 2015
257
258 0.54 - 30 Jan 2014, H.Merijn Brand
259 * Optional features required versions now builtin
260
261 0.53 - 29 Jan 2014, H.Merijn Brand
262 * Updated copyright to 2014
263 * Prefer Data::Peek over Data::Dumper
264 * Support (and prefer) Spreadsheet::ParseXLSX for .xlsx
265
266 0.52 - 05 Dec 2013, H.Merijn Brand
267 * Store CSV parse error - if any - in $ss->[0]{error}
268
269 0.51 - 30 Oct 2013, H.Merijn Brand
270 * Link xlsgrep during install
271
272 0.50 - 24 Oct 2013, H.Merijn Brand
273 * Added xlsgrep to examples
274 * Allow -C B,D for xlscat
275 * More prominent reference to xlscat in docs
276
277 0.49 - 11 May 2013, H.Merijn Brand
278 * /dev/null cannot be used for tests on Windows
279
280 0.48 - 14 Mar 2013, H.Merijn Brand
281 * Improve documentation consistency (RT#80409)
282 * Updated copyright to 2013
283 * Force old(er) tar format (ustar) - assumes GNU tar on release box
284 * Fix yml/json optional_features
285 * Install utilities from example by default
286 * Several minor changes (for maint)
287
288 0.47 - 30 Jun 2012, H.Merijn Brand
289 * Note that empty sheets are skipped when clip is true (RT#75277)
290 * Allow undef as valid value for the options (Max Maischein)
291 * Don't generate warnings when stripping whitespace and only
292 generating one of cells or rc. (Max Maschein)
293 * Fix test warning under perl-5.17.x
294
295 0.46 - 14 Feb 2012, H.Merijn Brand
296 * Updated copyright to 2012
297 * Support passing attributes to the underlying parser
298 * Do not strip fields in sheets with no cells at all (RT#74976)
299
300 0.45 - 07 Sep 2011, H.Merijn Brand
301 * NAME / DISTNAME in Makefile.PL
302
303 0.44 - 07 Sep 2011, H.Merijn Brand
304 * More cross-checks for META data
305
306 0.43 - 02 Aug 2011, H.Merijn Brand
307 * Changed name in META.yml (RT#69574)
308
309 0.42 - 01 Jun 2011, H.Merijn Brand
310 * Add --html output option to xlscat
311 * Force CSV parser when in-sep is given
312 * Prefer Data::Peek over Data::Dumper if available
313
314 0.41 - 06 Oct 2010, H.Merijn Brand
315 * Spell-check
316 * Fixed requiring optional modules (RT#61928 - Roderick Schupp)
317
318 0.40 - 31 Mar 2010, H.Merijn Brand
319 * Default option for clip fixed (RT#56151 - Alan James)
320
321 0.39 - 16 Mar 2010, H.Merijn Brand
322 * Doc fix (RT#54507, Patrick Cronin)
323 * Upped Copyright notices to 2010
324 * Drop YAML version to 1.0
325
326 0.38 - 15 Dec 2009, H.Merijn Brand
327 * Add row () and cellrow ()
328 * Updated META.yml to meet most recent specs (optional_features = map)
329
330 0.37 - 09 Nov 2009, H.Merijn Brand
331 * IO streams improvements
332 * MANIFEST fix
333
334 0.36 - 06 Nov 2009, H.Merijn Brand
335 * Add strip option
336 * Spreadsheet::XLSX 0.12 still does not support attributes
337 * Require Text::CSV_XS-0.69 for CSV for auto-detection of \r
338 * New attribute "parser" to force format
339 * Allow CSV streams
340 * Allow SC streams
341 * Allow XLS streams
342
343 0.35 - 03 Jun 2009, H.Merijn Brand
344 * Add Test::NoWarnings, which is not run in AUTOMATED_TESTING
345 * Switched to Test::More using tests_done ()
346 * Text::CSV_XS requires 0.43 or up, as we use ->eof ()
347 still prefer a really new release, like 0.65, which
348 is Test::NoWarnings safe
349 * Spreadsheet::XLSX 0.10 still does not support attributes
350 * Added -n to xlscat
351 * XLSX tests skip on feature, not on version
352
353 0.34 - 27 Jan 2009, H.Merijn Brand
354 * Spreadsheet::XLSX 0.09 still does not support attributes
355 still think it is better to follow closely. 0.09 is much
356 better than 0.08
357
358 0.33 - 23 Jan 2009, H.Merijn Brand
359 * A few Perl::Critic inspired changes
360 * Modified tests to prevent rounding errors (we were not checking for that)
361 * Added examples/ss-dups-tk.pl
362
363 0.32 - 06 Jan 2009, H.Merijn Brand
364 * Add basic support for M$ Excel 2007 using Spreadsheet::XLSX
365 * Test suite reports the parsers it found
366
367 0.31 - 04 Jan 2009, H.Merijn Brand
368 * Upped Copyright notices to 2009
369 * Detection of percentage type
370 * Even more reliable detection of Date types
371
372 0.30 - 22 Dec 2008, H.Merijn Brand
373 * Wrong e-mail in META.yml
374 * CSV files from a Mac, with \r as eol, would not parse
375
376 0.29 - 19 Oct 2008, H.Merijn Brand
377 * Make Read safer for files that do not match extension,
378 like HTML in foo.xls
379 * YAML declared 1.4 (META.yml) instead of 1.1 (YAML)
380 * Bring Makefile.PL in sync with META.yml
381 * Recommend Text-CSV-0.56
382
383 0.28 - 04 Sep 2008, H.Merijn Brand
384 * More tests on date formats
385 * Declare Spreadsheet::ParseExcel::FmtDefault in META.yml
386 * Add 'size' from Excel font size
387 * Update docs about Excel quirks and CPAN links
388 * Reference to public git repo
389 * Some typo's
390
391 0.27 - 31 Aug 2008, H.Merijn Brand
392 * Fixed META.yml (the specs are inconsistent)
393 * Added --dtfmt to xlscat
394
395 0.26 - 29 Aug 2008, H.Merijn Brand
396 * Added examples/xls2csv
397 * Upped copyright to 2008 in examples
398 * Don't ask to install examples under automated testing
399 * die => croak
400 * Added tgzdist target
401 * Added encoding options to examples/xlscat
402 * Added date-type checks for SS:PE > 0.32
403
404 0.25 - 02 Jan 2008, H.Merijn Brand
405 * Spreadsheet-Read now under git
406 * Upped copyrights to 2008
407 * Added all prereq's to Makefile.PL, even core mods
408 * Tested under perl-5.10.0
409 * Text::CSV as of 1.00 is OK
410
411 0.24 - 05 Oct 2007, H.Merijn Brand
412 * -? and --help in utils moved to Getopt::Long
413 * Adjusted copyright notice in utils
414 * removed prototypes in utils
415 * next is illegal in do {} while (); (Johan Vromans)
416 only happens with old Text::CSV_XS
417
418 0.23 - 21 Jun 2007, H.Merijn Brand
419 * Use IO::Scalar instead of File::Temp when installed
420 Thanks to David Cantrell for making a OpenBSD test box available!
421 * use binmode () when opening files
422 * Also use 3-arg open in test files
423 * die if test files cannot be opene'ed
424
425 0.22 - 18 Jun 2007, H.Merijn Brand
426 * 0.21 should already support Text::CSV_PP 1.05
427 Tested Text::CSV_PP 1.05 on bleadperl.
428 * Better detection of (not) installed modules
429 * Module requires perl 5.6.x
430
431 0.21 - 18 Jun 2007, H.Merijn Brand
432 * Text::CSV_XS uses keep_meta_info instead of get_flags
433 * Removed always_quote from xlscat's CSV output
434
435 0.20 - 31 May 2007, H.Merijn Brand
436 * perlcritic OK
437 * CSV parsing now uses getline (), and auto-detects eol
438 Assumes first line does not contain embedded eol. This implies that
439 parsing CSV with embedded eol sequences is now safe.
440 * As I now also maintain Text::CSV_XS, I changed the references
441 * Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)
442
443 0.19 - 04 May 2007, H.Merijn Brand
444 * Could not retreive '0' fields from OpenOffice (Jim Kelly)
445
446 0.18 - 27 Apr 2007, H.Merijn Brand
447 * use strict in Makefile.PL
448 * Added test_cover make target
449 * Added "ods" for OpenOffice conversions
450 * Added color tests for ods (but SR::RS doesn't support that yet)
451 * Switched from \d to 0-9 in regexp
452 * Added more test files and tests (increase coverage)
453
454 0.17 - 04 Jul 2006, H.Merijn Brand
455 * xlscat new option: --ansii to (try to) use the ansi colors for fields
456 * Fixed a color attribute off-by-one error
457 * Added test cases (not yet complete)
458 * Added bold and underline
459
460 0.16 - 04 Jul 2006, H.Merijn Brand
461 * xlscat new option: --in-sep-char to force-define input sep-char for CSV
462 * More debug lines
463 * Parser name info in $ref->[0]
464 * SquirrelCalc now reports Spreadsheet::Read and its version for parser info
465 * Most of the attributes for Excel now implemented. Tested, but no test case
466
467 0.15 - 21 Jun 2006, H.Merijn Brand
468 * Small doc change from AnnoCPAN
469 * Sheets with undefined labels might cause havoc
470 * Clip now skips empty xls sheets (TODO: sxc)
471 * xlscat clips by default
472 * xlscat new options -d and --noclip
473 * xlscat usage () from -?/--help to STDOUT from fault to STDERR
474
475 0.14 - 20 Jan 2006, H.Merijn Brand
476 * maxrow and maxcol were swapped in csv sheets
477 * promoted internal debug flag to option
478 * small doc changes
479
480 0.13 - 04 Nov 2005, H.Merijn Brand
481 * Control attrib 'cells' was misinterpreted
482 * New option: clip, default is true if {cell} is selected, false otherwise
483 Removes trailing lines and columns in each sheet that have no visible data
484 * new test t/11_call.t for checking options. Not complete yet
485 * Added test_cover target to Makefile.PL
486
487 0.12 - 31 Oct 2005, H.Merijn Brand
488 * Added ss2tk to examples
489
490 0.11 - 26 Oct 2005, H.Merijn Brand
491 * Allow ods (OpenOffice 2.0) for sxc
492 * include real ods test files and new test
493 * Check if sc.version is undef, not 0
494
495 0.10 - 19 Sep 2005, H.Merijn Brand
496 * More test coverage
497 * cr2cell () returns "" for illegal col/row values
498 * cell2cr () returns (0, 0) for illegal cell values
499 * rows () tests even better for valid reference pointer
500 * Renamed the test files
501
502 0.09 - 18 Sep 2005, H.Merijn Brand
503 * Added Test::Pod
504 * Added Test::Pod::Coverage
505 * Spreadsheet::ReadSXC 0.20 now required (too many tests fail on 0.12)
506 * Small changes to the docs
507 * More secure handling of false values
508 * Mention a bug in Spreadsheet::ParseExcel
509
510 0.08 - 22 Aug 2005, H.Merijn Brand
511 * Slightly changed the Synopsis
512
513 0.07 - 06 Jul 2005, H.Merijn Brand
514 * Added function rows ()
515 * Added function parses ()
516 * Made all modules optional
517 * Prepared for Spreadsheet::Perl
518 * Doc updates
519
520 0.06 - 22 Jun 2005, H.Merijn Brand
521 * Repaired error in label names in metadata for SXC
522
523 0.05 - 17 Jun 2005, H.Merijn Brand
524 * Spreadsheet::ReadSXC >= 0.20 supports sheet order
525 * Spreadsheet::ReadSXC has new data structure (we still support the old)
526 * Added "version" to the meta data for parser version
527 * More tests
528
529 0.04 - 14 Jun 2005, H.Merijn Brand
530 * Changed TODO
531 * Added options "rc", and "cell"
532 * Added CSV
533 * Added CSV options "sep", and "quote"
534 * Support xls from content
535 * Added basic support for SquirrelCalc format
536 * Updated pod
537 * xlscat -R option for row selection was a one-off
538 * xlscat now supports selecting fields with -F
539
540 0.03 - 19 May 2005, H.Merijn Brand
541 * Expanded xlscat to support -i for index
542 * Optionally install xlscat
543
544 0.02 - 19 May 2005, H.Merijn Brand
545 * Typoes in the doc
546 * Small change in organization so it actually installs
547
548 0.01 - 12 May 2005, H.Merijn Brand
549 * Initial CPAN version. A lot can still change