use Ben Nadel POI Utility (http://www.bennadel.com/projects/poi-utility.htm)
direct from a query or, just use cfcontent type=application/vnd.ms-excel
With a Table
2010/7/28 cfcom cf...@aceligent.com
I need to export to excel.
Will be provided only html pages that are not from cf server.
Sorry I didnt read it right
you have to receive the HTML data in a CFPage
maybe you can use a CFHTTP to call this page, and the content you output in
a XLS File.
But you have always to call a CFPage to Process!
Em 28 de julho de 2010 17h37min27s UTC-3, Rox Designer roberto...@gmail.com
:00 PM
To: CF-Talk
Subject: RE: CF to excel
You can create an html table and output that is an
excel file as follows:
CFSETTING ENABLECFOUTPUTONLY=YES
cfif parameterexists(EmpName)
cfinclude template=qry_employees.cfm
cfif qry_employees.recordcount gt 0
: Monday, March 14, 2005 9:32 PM
Subject: RE: CF to excel
I use this with success:
cfheader name=Content-Disposition value=attachment;
filename=#fileName#
cfcontent type=Application/Unknown reset=yes
[html content goes here...]
This code snippet should prompt you to download
How about removing the reset=yes?
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 6:57 AM
To: CF-Talk
Subject: Re: CF to excel
without the cfheader tags is the page loaind in the broiwser properly?
Adam H
On Mon, 14 Mar 2005 21:47:16
the page. Refreshes can generate errors when
sending non-HTML data through the response.
M!ke
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 5:57 AM
To: CF-Talk
Subject: Re: CF to excel
without the cfheader tags is the page loaind
-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 4:47 AM
To: CF-Talk
Subject: Re: CF to excel
Okay I tried your suggestion and got the same error
The page cannot be displayed
There is a problem with the page you are trying to reach
and it cannot
I use this with success:
cfheader name=Content-Disposition value=attachment;
filename=#fileName#
cfcontent type=Application/Unknown reset=yes
[html content goes here...]
This code snippet should prompt you to download/save each spreadsheet
w/o opening Excel directly.
M!ke
-Original
Internet Explorer
- Original Message -
From: Dawson, Michael [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, March 14, 2005 9:32 PM
Subject: RE: CF to excel
I use this with success:
cfheader name=Content-Disposition value=attachment;
filename=#fileName
At 12:19 PM 12/16/2002, you wrote:
When creating an excel spreadsheet with coldfusion, is there a way to
create what 'freeze panes' in excel does to lock the headers?
thanks,
seth
It's a part of the workbook's Windows property, in VBA you can access it
like this:
At 11:13 AM 22/10/02 -0400, Janine Jakim wrote:
I'm using the basic call to excel (as explained by BF in his book) because I
do know that all my users have excel.
My questions:
1. Can you add an excel toolbar- I want the users to be able to sort the
information on any of the columns.
2. Is
Thane
What exactly are web queries?
Thanks
Kola
-Original Message-
From: Thane Sherrington [mailto:tsherr;auracom.com]
Sent: 22 October 2002 16:24
To: CF-Talk
Subject: Re: CF to excel formatting questions
At 11:13 AM 22/10/02 -0400, Janine Jakim wrote:
I'm using the basic call
At 05:25 PM 10/22/02 +0100, Kola Oyedeji wrote:
Thane
What exactly are web queries?
A web query is created in Excel and allow Excel to read and import data
from a webpage. E-mail me offlist if you want more info.
T
~|
If all of your users have Excel, then you might look into using the
Microsoft Office web components. Web components allow you to embed an
activeX excel control on a web page -- inheriting the basic Excel
functionality. It's really the ultimate CFGRID replacement. Information
can be passed to
Is it just me or does CFGRID actually suck?
I just did a search on google for Microsoft Office web components, the
results are scary.
http://www.google.ca/search?hl=enie=UTF-8oe=UTF-8q=%22Microsoft+Office+we
b+components%22meta=
-Brook
At 02:07 PM 22/10/02 -0400, you wrote:
If all of your
/MSOWCPub.asp?HelpLCID=1
033Microsoft
Office Web site/a for more information./p
/object/div
/body
/html
-Original Message-
From: Brook Davies [mailto:brook;maracasmedia.com]
Sent: Tuesday, October 22, 2002 2:26 PM
To: CF-Talk
Subject: RE: CF to excel formatting questions
Is it just me
If you open the file directly into excel, this happens. (I deal with a lot
of UPC's with leading zeros). However, if you open excel, then import text
file, you have the opportunity to tell it how to treat each column
(selecting text for your zip column) and everything is then cool.
All else
thinking aloud.
1) export / import as a text field
2) single quote at the front of the field
How are you importing / exporting?
Eric Dawson
From: Nathan Shaw [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: cf to excel formatting problem
Date: Mon, 29 Oct
www.cfcomet.com has some really good examples of using Excel as a
datasource.
-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 21, 2001 1:19 PM
To: CF-Talk
Subject: Re: CF and Excel
fairly low tech approach but I have set up an access database
fairly low tech approach but I have set up an access database that links to
an excel spreadsheet that can be freely uploaded by site administrator. The
access database has the DSN mapping.
I use it so he can upload many new records at once, and is used as part of
an import process.
Eric
Have you looked here?
http://www.cfcomet.com
EC
-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 17, 2001 5:19 PM
To: CF-Talk
Subject: CF and Excel
Is there a way to read in an Excel worksheet into a cf app, possibly through
com,
Hi Janine,
If you're using oracle, there's a great way around this (and I'd assume sql
server has something similar). Use the nvl function in your query like so:
SELECTnvl(columnname, 0)
FROM yourtable.
nvl basically replaces nulls with something else. The only caveat is that
the
Believe it or not --
Windows 98 and higher has an Import to Excel function.
Just right mouse click on the coldfusion table you want to
turn into Excel, and a menu comes up saying Import to
Excel. It is NOT in Windows 95 though.
Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box
Message-
From: John Anderson [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 4:00 PM
To: CF-Talk
Subject: RE: CF to excel
You can create an html table and output that is an excel file as follows:
CFSETTING ENABLECFOUTPUTONLY=YES
cfif parameterexists(EmpName)
cfinclude
9:01 AM
To: CF-Talk
Subject: Format Tables (Was RE: CF to excel)
Thanks for all the input. Now for the next question. I am having a hard
time formatting my html table correctly. I am using TRTH#Skill[1]#/TH
TH#Skill[2]#/TH in the heading (I have also tried making it just a
regular TRTD/TD/TR
: RE: CF to excel
You can create an html table and output that is an
excel file as follows:
CFSETTING ENABLECFOUTPUTONLY=YES
cfif parameterexists(EmpName)
cfinclude template=qry_employees.cfm
cfif qry_employees.recordcount gt 0
cfset excelstring=table
-Original Message-
From: cf refactoring [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 10:38 AM
To: CF-Talk
Subject: Re: Format Tables (Was RE: CF to excel)
Can you show us the looping code? It's probably an
error in reusing too much of the sample code
--- Janine Jakim [EMAIL
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 10:38 AM
To: CF-Talk
Subject: Re: Format Tables (Was RE: CF to excel)
Can you show us the looping code? It's probably an
error in reusing too much of the sample code
--- Janine Jakim [EMAIL PROTECTED] wrote:
Thanks for all
Excel can read the following kinds of files:
comma delimited files
tab delimited files
HTML tables
I prefer HTML tables as you get to keep all the
formatting information.
For example, if you cut and paste the following table
code into a file
table
tr
tdbheading/b/td
tdiitalic/i/td
You can create an html table and output that is an excel file as follows:
CFSETTING ENABLECFOUTPUTONLY=YES
cfif parameterexists(EmpName)
cfinclude template=qry_employees.cfm
cfif qry_employees.recordcount gt 0
cfset excelstring=table
border=1trtdbFirst
It is just like from a database. Only difference is how you call the table.
CFQUERY NAME=getGrades DATASOURCE=datasource
SELECT DISTINCT [YOURFIELD] FROM `YOURTABLE$`
/CFQUERY
Make sure that you have the spreadsheet set up as a system DSN and then make
certain you place the ` in front
I do it a couple of ways. First, you can create a comma delimited file
(.csv) and then using cfcontent, deliver it right to the browser to be
downloaded, or you can write it to the server to be downloaded later. Or, I
often use the CFX_EXCEL custom tag from the exchange. You need Excel on the
David,
You got that error because Excel is not registered on your server. Assuming
that Excel is in fact installed on your server, you can register it by
following the directions at
http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=32381637-0922-41CA-
BBE305C2D66A7025#2.
Note that
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C02260.DCB649F0
Content-Type: text/plain;
charset="iso-8859-1"
you have to insert the comma characters in ascii format. ie.
PROBLEM: Want to dump results from a query into an
excel file using the cfcontent tag. This code worked
in CF 3.0 but after upgrading to 4.5 it dumps all the
data into one cell. What is causing this and how do I
get the data to dump into separate cells?
I have attached the code. It
Try this:
cfcontent type="text/x-excel-csv"CFOUTPUT#form.outputstring#/CFOUTPUT
S C [EMAIL PROTECTED] on 09/19/2000 12:10:17 PM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject: [CF-Talk] excel and CF
Actually, you can get very quick (and nice) results using a mime type of
"application/vnd.ms-excel" This lets you output your page as an html
table, formatting things very nicely in Excel.
--
Billy Cravens
[EMAIL PROTECTED]
Dave Watts wrote:
PROBLEM: Want to dump results from a query
see.
---
a href="\\castle_weba/reports/exptemp.csv"Click Here to open your report
in Excel!/a!--- \\castle_weba/d$/TEMP/exptemp.csv ---
!--- \\castle_weba/d$/reports/exptemp.csv ---
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 05, 2000 7:
e to open your report
in Excel!/a!--- \\castle_weba/d$/TEMP/exptemp.csv ---
!--- \\castle_weba/d$/reports/exptemp.csv ---
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 05, 2000 7:22 AM
To: [EMAIL PROTECTED]
Subject: Re: CF to Excel
The ea
The easiest way is to output an Excel readable text file, like a csv or tab
delimited file.
Cary
At 02:01 PM 6/2/2000 -0700, you wrote:
How can I take the results of a Query and save it as an Excel file?
This is what I though would work.
Thanks all!
CFQUERY NAME="DIMS" DATASOURCE="DSTS"
There are several Custom tags availabe on the Allaire tag gallery that will
allow you to do this if you want to do it that way. Try this:
http://devex.allaire.com/Developer/Gallery/SearchResults.cfm?keywords=excel
Hope that helps,
Sam Dutkin
Programmer
Internet Development
IBS Interactive
Try writing your output with CFFile
First, create a new file with your first line being a tab delimited column
head names:
cffile action="WRITE" file="C:/filepath/file.xls" output="Heading1
Heading2Heading3" addnewline="Yes"
Next, append your query results, again, delimit with tabs
42 matches
Mail list logo