cb_it
asked on
cfspreadsheet basics
Just getting back into CF after a long layoff of about 10 years!
Trying out the cfspreadsheet tag. I have a query, and I am able to get the xls file to be saved on my server - I just want a prompt displayed for the user to either open or save the file - can this be done with cfspreadsheet??
Thanks for any help!
Trying out the cfspreadsheet tag. I have a query, and I am able to get the xls file to be saved on my server - I just want a prompt displayed for the user to either open or save the file - can this be done with cfspreadsheet??
Thanks for any help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's a common problem w/documentation. It's too focused on explaining the single tag or function. Not enough common usage examples that show how to tie different things together. I understand why ... it's involved. Takes a lot of time to put together good examples. (Nothing worse than a bad or broken example). Still .. would be nice to see more of them.
(For the archives) Typo correction. The 2nd example should be:
<cfset theSheet = SpreadSheetNew()>
... add query data to sheet ...
<cfheader name="Content-Disposition" value="attachment; filename=someName.xls" >
<cfcontent type="application/vnd.msex cel" variable="#SpreadSheetReadBinary(t heSheet)#" >
<cfset theSheet = SpreadSheetNew()>
... add query data to sheet ...
<cfheader name="Content-Disposition"
<cfcontent type="application/vnd.msex
ASKER