> I have a page that is creating an excel spreadsheet using
> multiple queries.
> What happens is that a bunch of blank rows are generated in
> between the rows
> with data. This doesn't happen in the plain text file.
>
> I'd include the code, but it's long cause it's a many-tabled database that
> I'm attempting to flatten for the client. Ugh. I've used multiple
> loops, and
> it would appear that for each loop that is used, a blank line is
> added. I've
> tried wrapping all the output in <cfsetting enablecfoutputonly="yes"> But,
> that doesn't help.
Are you creating the spreadsheet via CFContent, a CSV or COM?
If it's a CFContent then you really have to be careful with the output -
ensure you're laying it out in a Table
If you're using a CSV, then build it as a string and write it with a CFFile
If you're using COM, then I can't see how any blanks get in...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
