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 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539
|
0.93 - 17 Mar 2025, H.Merijn Brand
* Add ranges and cellranges
0.92 - 06 Jan 2025, H.Merijn Brand
* Make strict_eol default to 1 for CSV when supported
* Show detected EOL for CSV in xlscat when known
* Add SECURITY.md
* It's 2025
0.91 - 27 Aug 2024, H.Merijn Brand
* Exclude OLE::Storage_Lite-0.21
* xlscat --head[=10], --tail[=10], --first=C
* Make (re)defining ->get_active_sheet safer
* Tested with perl-5.40
* xlscat --no-empty to skip empty columns too
* Spreadsheet::ParseExcel::FmtDefault might not be available
0.90 - 13 Feb 2024, H.Merijn Brand
* Consistent return value for parses ($type) on failure (issue#52)
* New options for xlscat (--no-empty, --clip=N)
* Support for hidden sheets
0.89 - 02 Jan 2024, H.Merijn Brand
* Auto-use BOM in CSV *files* with xlscat script
* Fix duplicate option letter (typo) (Erix)
* It's 2024
0.88 - 07 Nov 2023, H.Merijn Brand
* Guard $_ globbering from external bitrotted code
* Use recommended and suggested versions based on known CVEs
* Improve user feedback on failing xlsx2csv & xlscat
* Fix static docs for groff-1.24
* Basic support for Excel::ValueReader::XLSX (issue#50)
* Allow backend for parser option without version check
0.87 - 22 Feb 2023, H.Merijn Brand
* Change default #! to /usr/bin/perl (Tinita)
* Improve ->sheets (safer and docs)
* Update to Spreadsheet::ReadGnumeric 0.2 (attributes and small fixes)
0.86 - 07 Feb 2023, H.Merijn Brand
* Add Gnumeric support (Bob Rogers, THANKS!)
- work in progress, use with care, feedback welcome
0.85 - 04 Jan 2023, H.Merijn Brand
* Suggest the preferred parser if none found
* It's 2022
* xlscat --box and improvements for -L
* Add balloons to ss2tk buttons
* Fix typo in help (Erix)
* It's 2023
0.84 - 26 Feb 2021, H.Merijn Brand
* It's 2021
* Alias pivot to transpose (issue#36)
* Alias strip to trim (issue#36)
* Check for consistent return values of parses ()
0.83 - 21 Dec 2020, H.Merijn Brand
* Require ParseODS 0.26
* Add ::parsers to get list of supported formats
* Add --list to xlscat and xls2csv
* Update xls2csv to be identical to xlsx2csv
* ::parses ("") will return list of supported types
* Move installables from examples/ to scripts/
* Tested on FreeBSD-12.2-RELEASE with all supported backends
* Fix META issue for bugtracker
0.82 - 26 Sep 2020, H.Merijn Brand
* Move pod tests to xt (and do not distribute)
* Fix some links in the docs
* Add ".xlsm" to known XLSX file extensions
* Spreadsheet::ReadSXC has a new maintainer (Corion)
- support file handles
- suggest version 0.24 (0.22 causes fails)
* First attempt in supporting Spreadsheet::ParseODS (alpha code)
- version 0.25 should now pass the limited tests
- thanks to Corion for making this happen!
* It's 2020
* Fallback to Pod::Text if nroff not available in tools
* Extended support for merged cells with merge option
- Added $sheet->merged_from ("C2")
* Add --no-nl[=x] to xlscat
* xlscat: Align-right more numerics on -L (was only positive integers)
* xlsx2csv -Z : generate a ZIP file with a CSV for every sheet
* Doc fix (issue#33)
0.81 - 25 Aug 2019, H.Merijn Brand
* It's 2019
* Allow -c + --sep in xlscat
* Add --sep= to xls2csv for -A
* Add xlsx2csv to distribution (xlsx2csv has -A)
* Add -J s / --join str to xlsx2csv
* Add cpanfile
* Add explicit documentation about formatted vs unformatted
* Improve ->new behavior
* Auto-detect fallback for CSV now includes '|' for sep_char (PR#26)
0.80 - 31 Dec 2018, H.Merijn Brand
* Raise Spreadsheet::ParseXLSX minimum version to 0.24
* Improve docs on attributes
* Add attribute accessors
0.79 - 29 Aug 2018, H.Merijn Brand
* Environmant control hardening
* ReadData () docs (opening from scalar ref: issue#21)
* Check for XLSX content on opening from plain scalar content
* Fix typo in ss-dup-tk.pl (PRC, Branislav Zahradnik)
* Allow source from command line option in xls2csv (PRC, Branislav Zahradnik)
* Allow --in-sep=tab in xlscat/xlsgrep
* Add --hash to xlscat/xlsgrep
* Help and usage for examples/xls2csv (PR#23)
0.78 - 29 Jan 2018, H.Merijn Brand
* Spreadsheet::ParseExcel supports the active flag as of version 0.61
* Fix typo in docs (SPROUT, RT#124214)
0.77 - 22 Jan 2018, H.Merijn Brand
* Note possible name clashes with example/tool files
* Clipping and stripping more efficient
0.76 - 01 Jan 2018, H.Merijn Brand
* Allow streaming in xlscat
* Add --dump to xlscat
* Add error for opening ODS/SXC from reference
* It's 2018
0.75 - 09 Nov 2017, H.Merijn Brand
* Windows does not like an exec with arguments that have spaces (PR#15)
Three fixes by Andrew Gregory <andrew.gregory.8@gmail.com>). Thanks!
* Fix column clipping
* Manually generate cells to delete when clipping
* Skip cell deletion if they were never generated
* File names cannot have \0 in newer perls
0.74 - 27 Aug 2017, H.Merijn Brand
* Re-enable opening files with bad characters in the filename (issue#14)
0.73 - 30 Jul 2017, H.Merijn Brand
* Spreadsheet::XLSX::Reader::LibXML support completely dropped
* New options for ss2tk (font specs and SS labels)
* Safer xls2csv option parsing/passing
* Pass unknown command-line options to the parser
* Fix ReadData ("a,b,c\n1,2,3\n", parser => "csv")
* Drop 5.8.0 support. 5.8.1 is now minimum
0.72 - 25 May 2017, H.Merijn Brand
* get_active_sheet is only available as of Spreadsheet::ParseExcel 0.61
* Support password protected spreadsheets (implementation just for Excel)
* Do not warn on undefined labels (xlscat)
0.71 - 13 May 2017, H.Merijn Brand
* Use -w as intended
* Add option pivot
* No trailing spaces on xlscat -L
* Lexicalize code snippet (issue#12)
* Add attr method
* Remove special chars from worksheet name component (Windows, PR#13)
* Add refresh to ss2tk / csv2tk
* Add shortcut for UTF-8 output to xlscat
* Upgrade recommended modules to required for cpancover
0.70 - 02 Mar 2017, H.Merijn Brand
* Add label functionality to ::Sheet
* Add ->column and ->cellcolumn for ::Sheet
* Add col2label sub/method
* Sanitize xls2csv export filenames
* Fix sorting in xlscat for un-aligned columns
* It's 2017
* Be overly verbose about maxrow and maxcol being 1-based (RT#120476)
0.69 - 02 Dec 2016, H.Merijn Brand
* Several OO fixes, more tests, more docs
0.68 - 29 Nov 2016, H.Merijn Brand
* List non-core modules/version used on very verbose in xlscat
* Option to export all sheets in a spreadsheet to CSV (UTF-8 only)
* Add OO interface
* Feature: add new spreadsheets to existing book (even of different types)
0.67 - 17 Jun 2016, H.Merijn Brand
* CPANTESTERS showed that some versions really messed op numeric/percentage
0.66 - 16 Jun 2016, H.Merijn Brand
* Remove Spreadsheet::XLSX::Reader::LibXML test files from distribution
* Allow old versions of Spreadsheet::ParseXLSX to "fail" on percentage tests
0.65 - 15 Jun 2016, H.Merijn Brand
* Test with perl-5.24.0
* Show parser-version used under debug
* No more Spreadsheet::XLSX::Reader::LibXML
* Cells will inherit hidden state from hidden rows and columns
* Require 5.8.0 as 5.6.x does not include required Encode
0.64 - 22 Apr 2016, H.Merijn Brand
* It's 2016
* Allow inconsistent Spreadsheet::XLSX releases on Debian (tests)
* Decode utf-16be entries in Excel when appropriate
* Two examples in xlscat
0.63 - 10 Oct 2015, H.Merijn Brand
* Guard against negative MinRow in XLSX
* Documentation updated
* Support Spreadsheet::XLSX::Reader::LibXML disabled on author request
* Fix warning in utilities
* Check minimum parser version for pre-selected parser
0.62 - 16 Aug 2015, H.Merijn Brand
* Fix documentation structure
* Test all supported parsers (not just the preferred one)
* Basic support for Spreadsheet::XLSX::Reader::LibXML (work in progress)
* Copy example file if link fails (Alan Berndt)
* Add a contributing guide
0.61 - 13 Jun 2015, H.Merijn Brand
* Discourage Spreadsheet::XLSX
* A space is not an empty field in XLS
* Strip the correct selection (RT#105197)
0.60 - 30 Mar 2015, H.Merijn Brand
* No merged cell support in Spreadsheet::XLSX
0.59 - 26 Mar 2015, H.Merijn Brand
* Minimal support (+ docs) for merged cells
* Make parser errors report at one level up
* Don't select non-existing columns in xlscat
0.58 - 11 Feb 2015, H.Merijn Brand
* Remove perl recommendation from META as it breaks cpan clients
* Move sort instruction to correct place in xlscat's help
0.57 - 08 Feb 2015, H.Merijn Brand
* Moved project to github
* Add --sort to xlscat
* Clip before conversion
* Removed an unneeded localizing of $/ (related to p5 RT#123218)
0.56 - 05 Jan 2015, H.Merijn Brand
* printf does not play nice with encoding (related to RT#98436)
* default output UTF-8 if whole line is UTF-8
0.55 - 01 Jan 2015, H.Merijn Brand
* Mention Spreadsheet::CSV in documentation
* Add ssdiff to examples
* Amend xlscat -n to also number in HTML
* Updated copyright to 2015
0.54 - 30 Jan 2014, H.Merijn Brand
* Optional features required versions now builtin
0.53 - 29 Jan 2014, H.Merijn Brand
* Updated copyright to 2014
* Prefer Data::Peek over Data::Dumper
* Support (and prefer) Spreadsheet::ParseXLSX for .xlsx
0.52 - 05 Dec 2013, H.Merijn Brand
* Store CSV parse error - if any - in $ss->[0]{error}
0.51 - 30 Oct 2013, H.Merijn Brand
* Link xlsgrep during install
0.50 - 24 Oct 2013, H.Merijn Brand
* Added xlsgrep to examples
* Allow -C B,D for xlscat
* More prominent reference to xlscat in docs
0.49 - 11 May 2013, H.Merijn Brand
* /dev/null cannot be used for tests on Windows
0.48 - 14 Mar 2013, H.Merijn Brand
* Improve documentation consistency (RT#80409)
* Updated copyright to 2013
* Force old(er) tar format (ustar) - assumes GNU tar on release box
* Fix yml/json optional_features
* Install utilities from example by default
* Several minor changes (for maint)
0.47 - 30 Jun 2012, H.Merijn Brand
* Note that empty sheets are skipped when clip is true (RT#75277)
* Allow undef as valid value for the options (Max Maischein)
* Don't generate warnings when stripping whitespace and only
generating one of cells or rc. (Max Maschein)
* Fix test warning under perl-5.17.x
0.46 - 14 Feb 2012, H.Merijn Brand
* Updated copyright to 2012
* Support passing attributes to the underlying parser
* Do not strip fields in sheets with no cells at all (RT#74976)
0.45 - 07 Sep 2011, H.Merijn Brand
* NAME / DISTNAME in Makefile.PL
0.44 - 07 Sep 2011, H.Merijn Brand
* More cross-checks for META data
0.43 - 02 Aug 2011, H.Merijn Brand
* Changed name in META.yml (RT#69574)
0.42 - 01 Jun 2011, H.Merijn Brand
* Add --html output option to xlscat
* Force CSV parser when in-sep is given
* Prefer Data::Peek over Data::Dumper if available
0.41 - 06 Oct 2010, H.Merijn Brand
* Spell-check
* Fixed requiring optional modules (RT#61928 - Roderick Schupp)
0.40 - 31 Mar 2010, H.Merijn Brand
* Default option for clip fixed (RT#56151 - Alan James)
0.39 - 16 Mar 2010, H.Merijn Brand
* Doc fix (RT#54507, Patrick Cronin)
* Upped Copyright notices to 2010
* Drop YAML version to 1.0
0.38 - 15 Dec 2009, H.Merijn Brand
* Add row () and cellrow ()
* Updated META.yml to meet most recent specs (optional_features = map)
0.37 - 09 Nov 2009, H.Merijn Brand
* IO streams improvements
* MANIFEST fix
0.36 - 06 Nov 2009, H.Merijn Brand
* 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 - 03 Jun 2009, H.Merijn Brand
* 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 - 27 Jan 2009, H.Merijn Brand
* 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 - 23 Jan 2009, H.Merijn Brand
* 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 - 06 Jan 2009, H.Merijn Brand
* Add basic support for M$ Excel 2007 using Spreadsheet::XLSX
* Test suite reports the parsers it found
0.31 - 04 Jan 2009, H.Merijn Brand
* Upped Copyright notices to 2009
* Detection of percentage type
* Even more reliable detection of Date types
0.30 - 22 Dec 2008, H.Merijn Brand
* Wrong e-mail in META.yml
* CSV files from a Mac, with \r as eol, would not parse
0.29 - 19 Oct 2008, H.Merijn Brand
* 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 - 04 Sep 2008, H.Merijn Brand
* 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 - 31 Aug 2008, H.Merijn Brand
* Fixed META.yml (the specs are inconsistent)
* Added --dtfmt to xlscat
0.26 - 29 Aug 2008, H.Merijn Brand
* 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 - 02 Jan 2008, H.Merijn Brand
* 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 - 05 Oct 2007, H.Merijn Brand
* -? 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 - 21 Jun 2007, H.Merijn Brand
* 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 - 18 Jun 2007, H.Merijn Brand
* 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 - 18 Jun 2007, H.Merijn Brand
* Text::CSV_XS uses keep_meta_info instead of get_flags
* Removed always_quote from xlscat's CSV output
0.20 - 31 May 2007, H.Merijn Brand
* 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 - 04 May 2007, H.Merijn Brand
* Could not retreive '0' fields from OpenOffice (Jim Kelly)
0.18 - 27 Apr 2007, H.Merijn Brand
* 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 - 04 Jul 2006, H.Merijn Brand
* 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 - 04 Jul 2006, H.Merijn Brand
* 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 - 21 Jun 2006, H.Merijn Brand
* 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 - 20 Jan 2006, H.Merijn Brand
* maxrow and maxcol were swapped in csv sheets
* promoted internal debug flag to option
* small doc changes
0.13 - 04 Nov 2005, H.Merijn Brand
* 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 - 31 Oct 2005, H.Merijn Brand
* Added ss2tk to examples
0.11 - 26 Oct 2005, H.Merijn Brand
* 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 - 19 Sep 2005, H.Merijn Brand
* 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 - 18 Sep 2005, H.Merijn Brand
* 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 - 22 Aug 2005, H.Merijn Brand
* Slightly changed the Synopsis
0.07 - 06 Jul 2005, H.Merijn Brand
* Added function rows ()
* Added function parses ()
* Made all modules optional
* Prepared for Spreadsheet::Perl
* Doc updates
0.06 - 22 Jun 2005, H.Merijn Brand
* Repaired error in label names in metadata for SXC
0.05 - 17 Jun 2005, H.Merijn Brand
* 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 - 14 Jun 2005, H.Merijn Brand
* 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 - 19 May 2005, H.Merijn Brand
* Expanded xlscat to support -i for index
* Optionally install xlscat
0.02 - 19 May 2005, H.Merijn Brand
* Typoes in the doc
* Small change in organization so it actually installs
0.01 - 12 May 2005, H.Merijn Brand
* Initial CPAN version. A lot can still change
|