excel

The Verge
Scientists rename human genes to stop Microsoft Excel from misreading them as dates
"Excel doesn’t offer the option to turn off this auto-formatting, and the only way to avoid it is to change the data type for individual columns. Even then, a scientist might fix their own data, but as soon as someone else opens the same spreadsheet in Excel without thinking, errors will be introduced all over again."
Spock gripping computer the caption is [Sobbing Mathematically]
Recommended · Aug 7th, 2020, 6:43 am
harelba.github.io
q: Run SQL directly on CSV files
Have you ever been sitting there staring at an Excel spreadsheet thinking, "If I could just run a SQL query I'd have my answer." And then you have to export to CSV, import the thing into MySQL, and waste an hour figuring out why your import is failing. Anyway, this tool solves that particular problem nicely.
Recommended · Nov 19th, 2018, 8:38 am
Showing 1 through 2 of 2 posts tagged excel.