Catmandu::XLS(3pm)

πŸ“¦
version 0.11 Β· 2 versions
, in ubuntu resolute, ubuntu stonking

πŸ’– Catmandu::XLS πŸ’–

okay so bestie, welcome to Catmandu::XLS β€” the 3pm manual page for the modules that let you vibe with Excel .xls and .xlsx files. it's giving spreadsheets but make it perl. no cap, this is the one you want if your data is trapped in a workbook and you need it out. πŸ¦‹


✨ NAME ✨

Catmandu::XLS β€” modules for working with Excel .xls and .xlsx files πŸ’…


✨ SYNPOSIS ✨

(the original page spells it SYNPOSIS, and honestly? we respect the typo, we keep the typo 🫢)

convert Excel into CSV, like a little glow-up for your data:

# Convert Excel to CSV
$ catmandu convert XLS to CSV < ./t/test.xls > test.csv
$ catmandu convert XLSX to CSV < ./t/test.xlsx > test.csv

or slide it straight into JSON:

# Convert Excel to JSON
$ catmandu convert XLS to JSON
$ catmandu convert XLS

# Convert Excel to JSON providing own field names
$ catmandu convert XLS --field title,name,isbn

# Convert Excel to JSON using the column coordinates as field names
$ catmandu convert XLS --columns 1

and yes, it goes both ways β€” CSV can become Excel too, because the pipeline is a two-way street and we love that for it:

# Convert CSV to Excel
$ catmandu convert CSV to XLS < test.csv
$ catmandu convert CSV to XLSX  < test.csv
note: that last line has two spaces before < test.csv. that is exactly how the original prints it, and we are keeping it, character for character. periodt. ✨

✨ MODULES ✨

this is the squad, the main cast, the whole ensemble πŸ‘‘

  • Catmandu::Importer::XLS
  • Catmandu::Importer::XLSX
  • Catmandu::Exporter::XLS
  • Catmandu::Exporter::XLSX

✨ AUTHOR ✨

Nicolas Steenlant, "<nicolas.steenlant at ugent.be>" πŸŽ€


✨ CONTRIBUTOR ✨

the contributors really said "we're also in this" and we are so grateful πŸ’œ

  • Vitali Peil, "<vitali.peil at uni-bielefeld.de>"
  • Johann Rolschewski, "<jorol at cpan.org>"
  • Patrick Hochstenbach, "<patrick.hochstenbach at ugent.be>"

This software is copyright (c) 2013 by Nicolas Steenlant.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

tl;dr: it's free software, same terms as Perl 5 itself. go wild (responsibly). 🌈

and that's the whole page, bestie!! 🌸 this version came from perl v5.40.1, dated 2026-01-24, and it lives under the name Catmandu::XLS(3pm). go convert something iconic. πŸ’…βœ¨πŸ«Ά

πŸ“¦ where this page comes from