Excel file result in ColdFusion, creating new lines

I have several coldfusion pages set up that provide me with an Excel file from the database.  On the most recent one that I set up, I ask for the entire database.  One of the problems is there are around 30 fields, and when it creates an Excel worksheet, it creates a second line to fill in half of the data.  I want all the fields to appear in one line.  I do have a #carriage# at the end of it, but is there a way to tell it not to return in the middle?
LVL 1
ServalStudiosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gdemariaCommented:
when I export to excel I use an HTML table to place the data into the rows and columns.   How are you doing it?

Do you have any line breaks in your data?  you may have to search for them and replace them
0
ServalStudiosAuthor Commented:
I have it all like this

#membertype##tab##location##tab##anniversary##tab#

I use the

<CFHEADER NAME="Content-Disposition" VALUE="inline; filename=myfile.xls">
<CFCONTENT TYPE="application/vnd.msexcel">

Can I use the table with cells, etc, and it will still come out as an excel sheet using the above commands?
0
gdemariaCommented:
> Can I use the table with cells, etc, and it will still come out as an excel sheet using the above commands?

Yes, a table with cells will work the same way.   It may help delimit if you have line breaks in your data

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

gdemariaCommented:
perhaps you can set #tab# = "</td><td>"
and add
<tr><td> to the start of the line
and
</td></tr>
to the end of the line

with, of course, <table> and </table> at both ends

for a test..
0
ServalStudiosAuthor Commented:
Exporting it as a table is great.  Only problem is that I need to set a style for date and currency fields:



The one big problem I have is data with a return in it. I have tried putting < BR > in the field, but it ends up making another line in Excel
0
gdemariaCommented:
If you're having some trouble, you should add a post with your issue rather than closing the question with a B grade.   Most experts are willing to see you through to a complete conclusion.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.