Thanks for pointing me towards cfspreadsheet. There is probably a way to reduce a step, but for now this is working. This button calls the same query again and at the bottom I inserted the code below which writes to a spreadsheet and off to excel. On that page is a button to create a cfspreadsheet. So the user queries data and they are brought to the table posted above. I found some code from Raymond Camden's blog post that I was able make work for IE. Currently this immediately downloads when the submit button is selected. I used the following code to successfully download an HTML table to a spreadsheet via Chrome and IE (picked up from Raymond) but I am now looking for a way to display the data prior to download. I'm trying to export data from a query to an excel spreadsheet.
0 Comments
Leave a Reply. |