CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> Tips & Solutions

 Export to Excel - MySql text fields

Print topic Send  topic

Author Message
andrea

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:
<style>
br {mso-data-placement:same-cell;}
</style>

Hope it helps.

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

Awesome. Thanks for sharing.
kirchaj

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

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

Thanks for sharing.
TK

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

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 http://support.yessoftware.com.

MS Access to Web

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

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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