The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

spreadcomp - compare spreadsheets or databases

SYNOPSIS

spreadcomp -c <YAML-config-file> [-d] [-j] [-q] [-h] [-m]

Options:
    -c, --config
        YAML config file for comparison (required)

    -d, --debug
        Set the debug level (optional), possible values are:
          TRACE, DEBUG, INFO, WARN, ERROR or FATAL
        This can also be set with the environment variable
          SPREADSHEET_COMPARE_DEBUG

    -j --jobs
        Set the number of concurrent subprocesses to use (optional, defaults to 1)
        This will use threads under Windows which means that the non thread safe
        Text::CSV_XS cannot be used for CSV processing. By using Text::CSV_PP
        processing can be slower than using the default.

    -q --quiet
        Don't show the line counter while running.

    -h, --help
         Display this message

    -m, --manual
         Display complete manual (e.g. config file specifications)

    -v, --version
         Display version number and exit

DESCRIPTION

This is the command line frontend script for Spreadsheet::Compare a suite of perl modules for comparing spreadsheet like data and generating detailed reports about the found differences. The comparisons can be customized in various ways (ignore columns, set deviation limits, very large spreadsheet handling, etc.). The used config file structure allows for predefined suites designed to be run in automated regression tests.

The return code will represent the number of failed comparisons (with a maximum of 255).