Hello Again,
Have just been told to have another look at th esite I mentioned in my email
and it is no longer a custom tag download page - but have a look anyway, its
quite amusing. Instead go to the devcenter and search for HTML2Excel or try
this one
http://devex.allaire.com/developer/gallery/info.cfm?ID=82442819-BA47-11D4-83
E400508B94F85A&method=Full
Cheers
Simon
----- Original Message -----
From: "Simon Whittaker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 5:15 PM
Subject: Re: creating excel file in the REQUESTED format
> Hi there,
>
> I have used HTML2Excel which I got from http://www.coldfusionnet.com -
> works very well and is easy to setup.
>
> "This custom tag creates a dynamic Excel file from the generated content
of
> a block of ColdFusion code.
> The generated content is first saved as an HTML file.
> Then it is opened in Excel and saved with the .xls extension."
>
>
> Cheers
>
> Simon
> ----- Original Message -----
> From: "BEN MORRIS" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 29, 2001 5:02 PM
> Subject: Re: creating excel file in the REQUESTED format
>
>
> > My experience w/ option 2: don't do it. I made a tag myself that looped
> through query.fieldnames and it was extremely slow. It worked fine with a
> few hundred records, but getting into 1500 records pretty much rendered it
> useless, I got memory errors and it took forever to process.
> >
> > Even doing a simple loop with hard coded field names takes upwards of 60
> seconds to make a csv with 7000 records (about 20 fields of
> contact/membership information). The execution time is acceptable for
files
> with 1500 or so records in my case. If anyone knows of a better way to
make
> CSV, I am all ears... maybe a CFX tag would execute faster. My instinct
is
> to make a scheduled task to create all of the csv files I might need (over
> 1000 files), but I am afraid that would take too long to execute too.
> >
> > - Ben Morris
> >
> > >>> Critter <[EMAIL PROTECTED]> 08/29/01 11:25AM >>>
> > Hello Deanna,
> >
> > Option 1.
> > there is a tag in the gallery that will output to a csv file, it has
> some errors in
> > it, so those will need to be fixed....but other than that it works ok.
> >
> >
> > Option 2.
> > you could just loop thru the data, output the query.fieldnames, then
loop
> thru the
> > recordset and build your file.....and push it with cfcontent if you
> want....
> >
> > Option 1 - most of the work done for you......
> > Option 2 - opposite of option 1.
> >
> > --
> > Critter, MMCP
> > Certified ColdFusion Developer
> >
> > Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion">
> > -------------------------------------------
> > Wednesday, August 29, 2001, 11:26:12 AM, you wrote:
> >
> > DS> Hi Folks,
> > DS> I have a query that pulls data on various items for about 72
counties,
> > DS> quarterly for the last five years. I'm creating a downloadable excel
> file,
> > DS> and the client has requested that the data be presented like so:
> >
> > DS> INDICATOR COUNTYNAME1, COUNTYNAME2, COUNTYNAME3
> > DS> fs1 (date) value value
> > DS> value
> > DS> fs1 (anotherdate) value value
> > DS> value
> >
> > DS> I think I must be braindead today, cause I can't figure out how in
the
> heck
> > DS> I would get the data to layout like this without doing lots and lots
> of
> > DS> hardcoding. Here's the query that pulls all the data, if that's any
> help.
> >
> > DS> <cfquery name="getfs" password="#pword#" username="#uname#"
> > datasource="#dsn#">>
> > DS> SELECT f.item, c.name AS county, d.total, d.datecollected
> > DS> FROM flpweb.cfs_foodstampdata d, flpweb.cfs_foodstamp f,
> flpweb.cfs_county c
> > DS> WHERE c.countyid = d.countyid
> > DS> AND d.foodstampid = f.foodstampid
> > DS> ORDER BY c.name, f.item, d.datecollected
> > DS> </cfquery>
> >
> >
> >
> > DS> Deanna Schneider
> > DS> Interactive Media Developer
> > DS> [EMAIL PROTECTED]
> >
> >
> >
> >
> > DS>
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
