diff-xls-text - Diff the text of two Office spreadsheets (.ods, .xls, .xlsx) as two directories of CSV files
This document describes version 0.010 of diff-xls-text (from Perl distribution App-DiffXlsText), released on 2022-09-08.
Use like you would use the Unix command diff:
% diff-xls-text [options] <FILE>...
This is a wrapper for the Unix command diff. It assumes that each input file is an Office spreadsheet (.ods, .xls, or .xlsx) and tries to convert the file to a directory of CSV files (where each CSV file is converted from a single worksheet) using xlsx2csv. It then passes the converted directories to diff -ruN command.
diff -ruN
These are options that are interpreted by diff-xls-text and not passed to diff.
Please specify these options before file names.
--transpose-csv
Transpose CSV first using csv-transpose from App::CSVUtils. This allows you to do column-based instead of row-based diff.
If set to true, do not cleanup temporary directories.
String. Can be used to set path to diff command. See also "DIFF_XLS_TEXT_DIFF_CMD" which takes precedence.
String. Can be used to set path to diff command. The defaultl is diffwc if available in PATH, or diff. Takes precedence over "DIFF_CMD".
diff
Please visit the project's homepage at https://metacpan.org/release/App-DiffXlsText.
Source repository is at https://github.com/perlancar/perl-App-DiffXlsText.
Unix command diff.
ssdiff from Spreadsheet::Read which also diffs two spreadsheets but presents the result differently.
xlsx2csv from Spreadsheet::Read
perlancar <perlancar@cpan.org>
To contribute, you can send patches by email/via RT, or send pull requests on GitHub.
Most of the time, you don't need to build the distribution yourself. You can simply modify the code, then test via:
% prove -l
If you want to build the distribution (e.g. to try to install it locally on your system), you can install Dist::Zilla, Dist::Zilla::PluginBundle::Author::PERLANCAR, Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps required beyond that are considered a bug and can be reported to me.
This software is copyright (c) 2022, 2021, 2020 by perlancar <perlancar@cpan.org>.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=App-DiffXlsText
When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.
To install App::DiffXlsText, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::DiffXlsText
CPAN shell
perl -MCPAN -e shell install App::DiffXlsText
For more information on module installation, please visit the detailed CPAN module installation guide.