v2.6

• Cleanup
• Fixed an issue where passing directories were not working correctly
• Now only when excel file updated backup will be created

Full Changelog: v2.5...v2.6

v2.5

• Added possibility to pass sheets path inside query element. This will be concatenated with the root sheet paths
• Added option to set log level via '-l' or '--log-level' parameter
• Added option to set commercial usage via '-c' or '--commercial' parameter (if enabled you need to use EPPlus license file)
• Query file no longer needs parameter name you can pass it as argument after 'delete' or 'update' command (this is a breaking change)
• Fixed an issue where duplicated source files can be passed when passing directories
• Update cell function now checks if old value is same as new value before updating resulting in correct update count
• Added support for defining and reusing values in query files (values_def element)
• Added 'Throw' library for better error handling
• Improved exception messages
• Added possibility to run delete and update in single script. Removed update and delete argument instead it is passed inside query file. Which means it is possible to update and delete some rows in single script.

Full Changelog: v2.4...v2.5

v2.4

• Fixed an issue where JSON property name was not working correctly
• Fixed an issue where XML parsing was not working correctly due to wrong attribute usage
• Fixed an issue where query validation were not working for JSON and XML files
• Added more indepth tests

Full Changelog: v2.3...v2.4

v2.3

Fixed XML dictionary serialization issue
Refactored sheets model which caused syntax model change

Full Changelog: v2.2...v2.3

v2.2

• Fixed an issue where JSON and XML query files were not being read correctly

Full Changelog: v2.1...v2.2

v2.1

• Added support for JSON and XML query files

Full Changelog: v2.0...v2.1

v2.0

• Dumped the OpenXML SDK and switched to EPPlus for better file handling
• Reworked the query language to YAML instead of command parameters
• Added support for multiple filter queries
• Added support for multiple update queries
• Added support for AND and OR operators in filter queries
• Added support for parallel processing
• Added support for setting header row number
• Added support for setting start row number
• Added 2 new compare operators IS_NULL_OR_BLANK and IS_NOT_NULL_OR_BLANK
• Better separation of methods
• Improved error handling
• Improved logging
• Improved data type validation and conversion with YAML deserialization
• Improved data validation
• Removed first row update parameter
• Updated syntax to support multiple column updates in query
• Implemented delete functionality
• Added tests project
• Implemented backup feature
• Refactored REPLACE, BETWEEN and NOT_BETWEEN operators

Full Changelog: v1.4...v2.0

v1.4

• Added support for directory path
• Added support for multiple -f parameters

Full Changelog: v1.3...v1.4

v1.3

• Added possibility to update without filter query

Full Changelog: v1.2...v1.3

v1.2

• Syntax change
• Added support for multiple column names in single filter query
• Added support for multiple values in single set query

Full Changelog: v1.1...v1.2