spreadsheet excel writer output truncated

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
spitfire_esquive
Forum Commoner
Posts: 37
Joined: Sun Nov 06, 2005 6:46 am

spreadsheet excel writer output truncated

Post by spitfire_esquive »

hi guys, i was just wondering if any of you experienced this truncation when using pear spreadsheet excel writer. i have this field in my mysql databas that is "text" in nature (meaning long text is to be put in in that specific column) and when i output the data using the mentioned excel writer it is truncated. i used htmlspecialchars and stripslashes hoping that it would work but unfortunately it has not. any input would be much appreciated!

thanks,
niño
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

If you're storing all this text into a single cell, I would imagine there is a (rather short) limit to how much data can be packed into a single cell. Try breaking the text up into smaller chunks.
Post Reply