Re: line breaks in excel

2001-03-06 Thread Deanna L. Schneider
Hm...I was using cfcontent (code snippet from a previous post by Ben Forta) to create a csv file. We don't have the necessary stuff to use com for this. I would just use the cf_excel custom tag (which we have installed) but I need more control than that affords. I've got it working now, at least o

Re: line breaks in excel

2001-03-06 Thread Deanna L. Schneider
Since I posted I figured out that if I put all my code on line 1, I don't have the white space problem. But, sheesh. Talk about ugly code! I'll try cfsilent, too. d Deanna Schneider Interactive Media Developer UWEX Cooperative Extensi

RE: line breaks in excel

2001-03-06 Thread Philip Arnold - ASP
> 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 >

RE: line breaks in excel

2001-03-06 Thread Patricia Lee
g works to strip out even the most persistent white space maybe it will help. |-Original Message- |From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 06, 2001 1:51 PM |To: CF-Talk |Subject: line breaks in excel | | |Hi folks, |I have a page that is creatin

line breaks in excel

2001-03-06 Thread Deanna L. Schneider
Hi folks, 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