search

EnlightenedPerlOrganisation / task-kensho

A Glimpse at an Enlightned Perl Distribution
http://search.cpan.org/dist/Task-Kensho
Other
71 stars 23 forks source link

Support XLSX #71

Open Tux opened 3 years ago

Tux commented 3 years ago

The suggested modules for Excel/CSV are

The first two depend on Spreadsheet::ParseExcel and Spreadsheet::WriteExcel which is fine for .xls files, but neither works on modern .xlsx files.

I suggest to at lease at Spreadsheet::ParseXLSX and Excel::Writer::XLSX to support (more) modern Excel.

For Spreadsheet reader/parser support, I'll be bold to suggest my own Spreadsheet::Read, which is a uniform layer over (most) spreadsheet reader/parser modules (ODS, SXC, XLS, XLSX, CSV, SQ)

I'm not aware of a likewise module for writing (yet).

Grinnz commented 3 years ago

Sort of duplicate of https://github.com/EnlightenedPerlOrganisation/task-kensho/issues/48

karenetheridge commented 3 years ago

We should definitely note the issue with .xlsx files; I wasn't aware of this.

rabbiveesh commented 3 years ago

I'm not aware of a likewise module for writing (yet).

There's Spreadsheet::Write and Spreadsheet::Wright, which both support XLSX and CSV at the very least.