Scroll to navigation

Catmandu::XLS(3pm) User Contributed Perl Documentation Catmandu::XLS(3pm)

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

MODULES

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

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>"

COPYRIGHT AND LICENSE

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.

2020-04-02 perl v5.30.0