ch subject/grade. If I just
> > put #Skill# in the header
> > it only gives me the 1st skill... Any ideas???
> >
> > -Original Message-
> > From: John Anderson [mailto:[EMAIL PROTECTED]
> > Sent: Monday, September 17, 2001 4:00 PM
> > To: CF-Tal
ite wide
error handler?
/t
>-Original Message-
>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 displaye
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 in the
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 200
chael" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Monday, March 14, 2005 9:32 PM
> Subject: RE: CF to excel
>
> > I use this with success:
> >
> >
> >
> >
> > [html content goes here...]
> >
> >
> > This co
Internet Explorer
- Original Message -
From: "Dawson, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, March 14, 2005 9:32 PM
Subject: RE: CF to excel
> I use this with success:
>
>
>
>
> [html content goes here...]
>
>
I use this with success:
[html content goes here...]
This code snippet should prompt you to download/save each spreadsheet
w/o opening Excel directly.
M!ke
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 9:22 PM
To: CF-Talk
Subject: CF t
le>
<LeftColumnVisible>0</LeftColumnVisible>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
">
To use this Web
page interactively, you must hav
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=en&ie=UTF-8&oe=UTF-8&q=%22Microsoft+Office+we
b+components%22&meta=
-Brook
At 02:07 PM 22/10/02 -0400, you wrote:
>If all of y
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 the
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
~|
Arch
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 2
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
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
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 fails
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 replac
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 279
>
> -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
&g
Grade#
-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 sh
-
> 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:
>
>
>
>
>
>
>
.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 9:01 AM
To: CF-Talk
Subject: Format Tables (Was RE: CF to excel)
Thanks for all the input. Now
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:
First Name">
It is just like from a database. Only difference is how you call the table.
SELECT DISTINCT [YOURFIELD] FROM `YOURTABLE$`
Make sure that you have the spreadsheet set up as a system DSN and then make
certain you place the ` in front of your tablename and the $` after your
table name.
You can create an html table and output that is an excel file as follows:
First Name">
Last
Name">
Office
Phone">
Mobile
Phone">
Pager">
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
heading
italic
colored
dat
!
-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 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
Click Here to open your report
in Excel!
-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 easiest way is to output an Excel readable text file, like a
Try writing your output with CFFile
First, create a new file with your first line being a tab delimited column
head names:
Next, append your query results, again, delimit with tabs -- you'll want to
surround your CFFile-append with a CFLoop query loop:
H.
=
Howar
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 (NAS
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!
>
>
> SELECT END_ITEM_ROO
30 matches
Mail list logo