Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells...

biswanath_c has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by runrig (Abbot) on Oct 15, 2009 at 18:36 UTC
See the example program autofit.pl that comes with the Spreadsheet-WriteExcel distribution.	[reply]
Re^2: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by biswanath_c (Beadle) on Oct 15, 2009 at 20:53 UTC
I was not able to find that perl script anywhere in my machine. I am pretty much sure it did not come with the installation for me! The documentation for Format was empty! It did not list any methods or the usage description!!	[reply]
Re^3: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by toolic (Bishop) on Oct 15, 2009 at 20:59 UTC
I was not able to find that perl script anywhere in my machine. I am pretty much sure it did not come with the installation for me! You can just grab the autofit.pl script from CPAN.	[reply]
Re: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by ww (Archbishop) on Oct 15, 2009 at 18:27 UTC
Have you checked "Spreadsheet::WriteExcel::Format - A class for defining Excel formatting"? Update: Unborked the link	[reply]
Re^2: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by biswanath_c (Beadle) on Oct 15, 2009 at 20:50 UTC
Is there a documentation for Format?	[reply]
Re: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by biohisham (Priest) on Oct 16, 2009 at 01:07 UTC
This is my favorite Spreadsheet::WriteExcel source of examples listed and grouped together in a nice way here at this link, it got a couple of examples about colors, you can even programmatically control cells to display colors based on conditions regarding the contents they have, like red for negative values, blue for zero and green for positive values or any other combination of colors and conditions. Probably you meant automatic resizing of columns to the size of the longest string a cell in that column can have. There's a function called Autofit. However get yourself familiarized with formats in Spreadsheet::WriteExcel so you can explore the multitude of other options you can get. Excellence is an Endeavor of Persistence. Chance Favors a Prepared Mind.	[reply] [d/l]