Spreadsheet-Read

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

    * 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



( run in 1.555 second using v1.01-cache-2.11-cpan-39bf76dae61 )