*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Ho! Ho! Ho! and Greetings to All the Good Little TG Girls and Boys!
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Once in a while, Santa stumbles upon a web code goodie that is not only easy to use, but also has some useful possibilities. One such goodie is SheetJS.  It allows one to download an HTML table as an Excel file.

https://github.com/sheetjs/sheetjs

It's far too much work to decipher how to make it work by reading all the instructions and then trying to get it to work. It's much easier to just view the source of this simple example and use it as a starter whenever you want to use SheetJS:

https://neth.roe3.org/santa/Export2Excel.html

Basically, whatever is displayed in the table on the screen is what gets downloaded in the XLSX file when you press the [Export] button. Here's a simple directory that's hitched up to it so that you can play around and see what it can do:

https://cloud.roe3.org/bfemail/bfemail2.php

Filter it, sort the columns . . . whatever's on the screen is what winds up in the spreadsheet. Now if Santa could only find how to bypass the spreadsheet download altogether and push it directly to a Sheet in his GSuite Drive. Ho! Ho! Ho!

Your friend,
Santa

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Santa Claus
Right Down Santa Claus Lane
North Pole 00000
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*