3 ms·
Unless I'm missing something, this only provides a way to display data from a database. But users cannot write to the database via the Google Sheet, and it thu
by roadnottaken 9y ago
Unless I'm missing something, this only provides a way to display data from a database. But users cannot write to the database via the Google Sheet, and it thus doesn't solve the problem...
- fragsworth 9y agoOh god you're right, I just re-read the article and realized what they're doing now. It didn't even occur to me that anyone would use Excel as the database. Holy hell. Nevermind. Still, it shouldn't be hard to convert Excel to an SQL database. Then you dump to CSV, and use ImportHTML to have a spreadsheet be your source of information.
- Amezarak 9y agoExcel can use databases as a data source, there's no need for all your extra steps.