I need to export to excel.
Will be provided only html pages that are not from cf server.
Is there a way to set up an import feature to regrab the html data (name,
company, address, etc fields) back into CF so it can be easily exported to
excel?
Thank you
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
How come the following will not work. I get a 500 error
html
head
titleCLASS of cfoutput#getYRInfo.class_year#/cfoutput Spread Sheet/title
/head
body
cfcontent type=application/ms-excel
CFHEADER NAME=content-disposition VALUE=filename=classroster.xls
cfoutputtable cols=11/cfoutput
cfoutput
Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 9:22 PM
To: CF-Talk
Subject: CF to excel
How come the following will not work. I get a 500 error
html
head
titleCLASS of cfoutput#getYRInfo.class_year#/cfoutput Spread
Sheet/title /head body
cfcontent type
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
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
This message is for the named person's use only. It may contain sensitive and private
proprietary or legally privileged information. No
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:
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 there any way to get it so that the headings can
. Is there any way to get it so that the headings can wrap. Some of my
headings are long so instead of making a long stretchy heading.
Thanks in advance for any help.
I did my CF to Excel functionality by using webqueries. They work well,
and since the data is in Excel, one can use all of Excel's
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
~|
to the control as XML.
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Tuesday, October 22, 2002 11:14 AM
To: CF-Talk
Subject: CF to excel formatting questions
I'm using the basic call to excel
.
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
-Original Message-
From: Janine Jakim [mailto:jjakim;albemarle.org]
Sent: Tuesday, October 22, 2002 11:14 AM
To: CF-Talk
Subject: CF to excel formatting questions
I'm using the basic call to excel (as explained by BF
/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
I am exporting some data to Excel and one of the
fields is zip code. Excel is stripping all leading 0's
(zeros) off of the zip codes. I need it to leave the
zip code alone, i.e. treat it as text instead of a
number. Any ideas anyone?
So far, I have tried:
1) Using an obscure ASCII char in front
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
Dawson
From: Scott Mulholland [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: CF and Excel
Date: Wed, 17 Oct 2001 17:18:40 -0400
Is there a way to read in an Excel worksheet into a cf app, possibly through
com, without using excel as the datasource?
Thanks,
Scott
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
Is there a way to read in an Excel worksheet into a cf app, possibly through
com, without using excel as the datasource?
Thanks,
Scott
~~
Structure your ColdFusion code with Fusebox. Get the official book at
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
I have set up an excel sheet to show results of a search. I also want to
add another search- when the field is null or X. The query works, however,
it does not show up correctly on the excel sheet.
1. The excel sheet does not line the nulls under the correct headings. No
matter where on the
279
Watertown MA 02471-0279
Email: [EMAIL PROTECTED]
http://www.juliagreen.com
Phone: 617-926-3413
Fax: 617-812-5935
- Original Message -
From: Janine Jakim [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 3:39 PM
Subject: CF to excel
How flexible
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
How flexible is the process of generating excel files?
I need to have an output that is dynamic for the columns and rows.
For example:
#student# #student# #student# #student#
#Skill# #grade# #grade# #grade# #grade#
#Skill# #grade# #grade# #grade# #grade#
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
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 12:40 PM
To: CF-Talk
Subject: CF to excel
How flexible is the process of generating excel files?
I need to have an output that is dynamic for the columns and rows.
For example
, September 17, 2001 2:40 PM
To: CF-Talk
Subject: CF to excel
How flexible is the process of generating excel files?
I need to have an output that is dynamic for the columns and rows.
For example:
#student# #student# #student# #student#
#Skill# #grade# #grade
PM
Subject: CF and Excel
Hello, i've been tasked with taking data out of a SQL database and
inserting
it into an excel spread sheet. I went to CFComet and read through their
instructions and ran their sample code, but i cannot get it to work. I get
the following error:
Error Diagnostic
Hello, i've been tasked with taking data out of a SQL database and inserting
it into an excel spread sheet. I went to CFComet and read through their
instructions and ran their sample code, but i cannot get it to work. I get
the following error:
Error Diagnostic Information
Error trying to create
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
Hello all I have a requirement for reporting to go to excel.
The excel part is no problem.
The problem lies in that the client wants headers, footers and logos to
print on every page of the report.
I have found good information on the comet http://www.cfcomet.com/cfcomet/
site but has anyone
done this? Excel would be a pretty flexible tool to create some
quick web database interfaces.
Eric
From: "Eric Dawson" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Excel and CF
Date: Thu, 04 Jan 2001 08:39:54 -0600
OT but not OT.
I have been
om.
Has anyone done this? Excel would be a pretty flexible tool to create some
quick web database interfaces.
Eric
From: "Eric Dawson" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Excel and CF
Date: Thu, 04 Jan 2001 08:39:54 -0600
OT
and CF (using Excel to post data to server)
Date: Thu, 04 Jan 2001 10:45:22 -0600
Actually, you could build a VBA macro that utilizes WDDX. That way you
could simply run the macro from a normal spreadsheet and have it post to
a website (without having to build a "web" interface) T
--0-1884661237-969379817=:10166
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
I am looking for someone who has had the same problem
that I am having and has suggestions on how to
overcome it.
PROBLEM: Want to dump results from a query into an
excel file using the
format. ie.
cfoutput#variable1##chr(9)##variable2##chr(9)#/cfoutput
-Original Message-
From: S C [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 19, 2000 12:10 PM
To: [EMAIL PROTECTED]
Subject: [CF-Talk] excel and CF
--0-1884661237-969379817=:10166
Content-Type: text/plain; charset=us-asc
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
--0-1884661237
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"
(NASDAQ: IBSX)
Phone: (856) 985-5200, x 101
Fax: (856) 985-3363
[EMAIL PROTECTED]
-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 02, 2000 5:01 PM
To: [EMAIL PROTECTED]
Subject: CF to Excel
How can I take the results of a Query and save it as an Excel
=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=
-Original Message-
From: Ray, James A [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 02, 2000 2:01 PM
To: [EMAIL PROTECTED]
Subject: CF to Excel
How can I take the resu
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"
SELECT END_ITEM_ROOT_PN, END_ITEM_SN
FROM DSTS.B_V_DSTS_ASSEMBLY
ORDER BY END_ITEM_ROOT_PN,
57 matches
Mail list logo