CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> Tips & Solutions

 Export to Excel - MySql text fields

Print topic Send  topic

Author Message

Posts: 18
Posted: 10/17/2011, 11:24 AM

Tested with PHP+MySql.
When exporting to Excel from a table containing TEXT fields, following the example from CCS Example Pack, every carriage return + line feed is converted to a <br>. This forces Excel to a new row.
To have your text in a single cell add in the <head> section:
br {mso-data-placement:same-cell;}

Hope it helps.

View profile  Send private message
Posted: 10/17/2011, 5:50 PM

Awesome. Thanks for sharing.

Posts: 215
Posted: 10/18/2011, 6:30 AM

I had this very problem earlier this week. I will try with Postgres and report the outcome.

Thanks for sharing.

Works like a charm with Postgres too ;)
View profile  Send private message

Posts: 18
Posted: 10/18/2011, 9:50 AM

Good to know! :-)
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.