Overview

loadsheets appends rows to an existing Excel “template” file from one or more Excel “source” files as directed by a configuration file.

This approach provides a simple, automated way to create “loadsheets” of new product information as required by several industry retailers and distributors.

Features

1. Excel (xlsx) and CSV files are used for source data.

2. Excel (xlsx) files are used for template layout (and final output).

3. Multiple source files (or worksheets) can be used (joined together by part number).

4. Coded (“stacked”) data sources are supported (e.g. multiple rows per part number: Part, Code, Description).

5. Console application allows automated processing.

6. Data validation at the field level.

7. Data validation between fields (including conditional requirements).

8. One or more fields may be used for filtering rows with full Boolean expressions.

   $LINE_CODE == "XYZ" && $POP_CODE in ["A","B"]

9. Option to include runtime parameters for filtering or other conditional validation.

   loadsheets -config oreilly.yaml -params "p1=ABC"
   $LINE_CODE == p1

10. Built-in functions are provided for use in conditional expressions.

    $EFF_DATE < Today()
    $EFF_DATE < Date(p1)

11. Log file includes complete error descriptions with cell references (for both input and output identification).

12. Option to highlight any cells with errors in the output file.

13. All output values default to string values, with the ability to force Excel native data types if required.