Solved

PEAR - Spreadsheet Excel Writer - Autofit?

Posted on 2008-10-25
2
2,271 Views
Last Modified: 2013-11-10
Is there a way to set the columns to autofit?  
0
Comment
Question by:n00b0101
2 Comments
 
LVL 50

Accepted Solution

by:
Steve Bink earned 500 total points
Comment Utility
See here for one explanation:

http://groups.google.com/group/spreadsheet-writeexcel/browse_thread/thread/e97641b4cde64b93?pli=1

I hit the same problem when I was working with Excel Writer.  I fixed it by setting TextWrap on the cell format, and using a cell width that was likely to match the wider entries.  
0
 

Author Closing Comment

by:n00b0101
Comment Utility
Thanks for the info!  I'll try what you did.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now