NAME

diff-xls-text - Diff the text of two Office spreadsheets (.ods, .xls, .xlsx) as two directories of CSV files

VERSION

This document describes version 0.007 of diff-xls-text (from Perl distribution App-DiffXlsText), released on 2021-07-07.

SYNOPSIS

Use like you would use the Unix command diff:

 % diff-xls-text [options] <FILE>...

DESCRIPTION

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 xls2csv. It then passes the converted directories to diff -ruN command.

OPTIONS

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.

ENVIRONMENT

DEBUG

If set to true, do not cleanup temporary directories.

DIFF_XLS_TEXT_DIFF_CMD

String. Can be used to set path to diff command. The defaultl is diffwc if available in PATH, or diff.

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/App-DiffXlsText.

SOURCE

Source repository is at https://github.com/perlancar/perl-App-DiffXlsText.

BUGS

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.

SEE ALSO

Unix command diff.

ssdiff from Spreadsheet::Read which also diffs two spreadsheets but presents the result differently.

xls2csv from Spreadsheet::Read

AUTHOR

perlancar <perlancar@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2021, 2020 by 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.