You may have seen the headlines about a Microsoft employee calling AI scraping “the largest theft of labor in human history.” It made the rounds on social media, with plenty of people i…
one that loads an excel file into an SQLite database with one table per tab (this will give you an easy import path)
one that exports a SQL query to an excel file. (This will enable easy export)
one that reads a text file containing formatting instructions (font size, color, merging cells, drop downs, vertical and horizontal alignment) and applies it to an excel file. (This enables common formatting templates and start you heading towards more custom automation workflows)
C# with epplus loading data from Excel into an SQLite database and from the SQLite database to Excel files is extremely common in work environments.
Im not a dev my stuff is like locked down by IT but they do know about the issue and the guy is definitely open minded to trying other things.
Ask for 3 command line programs:
one that loads an excel file into an SQLite database with one table per tab (this will give you an easy import path)
one that exports a SQL query to an excel file. (This will enable easy export)
one that reads a text file containing formatting instructions (font size, color, merging cells, drop downs, vertical and horizontal alignment) and applies it to an excel file. (This enables common formatting templates and start you heading towards more custom automation workflows)