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).