Prev: Locking and Objects
Next: what is the best format for urls when it comes to seo
From: biene22 on 4 Apr 2008 01:59
Hello,

I want to export a dynamic query result via button to excel.
I have a search template from where the users want to export the query results
by clicking a button to an excel file.
Is it possible?:confused;

From: GArlington on 4 Apr 2008 04:44
On Apr 4, 6:59 am, "biene22" <webforumsu...(a)macromedia.com> wrote:
> Hello,
>
> I want to export a dynamic query result via button to excel.
> I have a search template from where the users want to export the query results
> by clicking a button to an excel file.
> Is it possible?:confused;

Just create a csv format:
1st row query column headers
then 1 row per record.
Do NOT forget to insert line breaks after each row.
From: prasanth25 on 4 Apr 2008 08:15
Hi,
Try adding the header

<CFHEADER NAME="Content-Disposition" VALUE="attachment;
FILENAME=resultFiles.xls">
<CFCONTENT TYPE="application/vnd.msexcel">

to the file and try. This will open the output file as an Excel document.

- Prasanth

From: Dan Bracuk on 4 Apr 2008 08:03
Make the query a session variable. When the user clicks the button, take them to another page where you can use cfheader and cfcontent to export to excel.
From: "JR "Bob" Dobbs" on 4 Apr 2008 08:58
Here is a list of options.
http://www.carehart.org/resourcelists/tools_to_consider/index.cfm#excel
 |  Next  |  Last
Pages: 1 2
Prev: Locking and Objects
Next: what is the best format for urls when it comes to seo