this post was submitted on 24 Dec 2023
98 points (96.2% liked)
Today I learned
7850 readers
1 users here now
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Anyone else here use R (+ openxlsx2) + SQLite to produce Excel reports? I’m finding that to be way better than flat file bullshit and writing macros.
I started a project trying to use excel to analyse data, but quickly found that it's very limited, then I dumped the data into SQLite and added a statistics plugin, and bingo!