[jQuery] One click spreadsheet from table
Thinking out loud.... I want to create a one-click solution that turns
any table into a CSV file and opens the CSV file with whatever app is
the default for .csv files. I know that I can turn any result set into
a CSV file with PHP, but that involves writing a file to disk and then
prompting the user to go open the files with whatever spreadsheet
program. Plus, I'd have to implement it one result set at a time.
On the other hand jQuery could order and filter the results on the
client side (already doing this), and I could scrape the DOM and get
the table using jQuery, but I still don't want to try getting the
useless, er, rather, users to jump through the (albeit simple) hoops
of saving and opening the file. Any ideas for that end? The goal is
one click and, bang, Excel (or whatever) opens with your data set.