Sequel is a simple, flexible, and powerful SQL database access toolkit for Ruby. Sequel provides thread safety, connection pooling and a concise DSL for constructing SQL queries and table schemas.
VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...