53
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 23 Sep 2026
53 points (98.2% liked)
Libre Culture
160 readers
3 users here now
Libre Culture
The Best Place for Libre Culture Content on Lemmy.
Forum Rules
On top of the rules of this instance, the following additional rules apply.
- Be Kind to Each Other
- Stay On Topic
About Libre Culture
The Libre Culture movement, also called the Free Culture movement, is a social movement constructed around the free exchange of ideas.
founded 2 years ago
MODERATORS
For small excel files use LibreOffice. For big ones SQLite. Then you have access to much better tooling.
It's for work
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)