logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

Catmandu::XLS - modules for working with Excel .xls and .xlsx files

Author

       Nicolas Steenlant, "<nicolas.steenlant at ugent.be>"

Contributor

       Vitali Peil, "<vitali.peil at uni-bielefeld.de>"

       Johann Rolschewski, "<jorol at cpan.org>"

       Patrick Hochstenbach, "<patrick.hochstenbach at ugent.be>"

Modules

       •   Catmandu::Importer::XLS

       •   Catmandu::Importer::XLSX

       •   Catmandu::Exporter::XLS

       •   Catmandu::Exporter::XLSX

Name

       Catmandu::XLS - modules for working with Excel .xls and .xlsx files

Synposis

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

           # 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

           # Convert CSV to Excel
           $ catmandu convert CSV to XLS < test.csv
           $ catmandu convert CSV to XLSX  < test.csv

See Also