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.

In reply to Re: Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by biohisham
in thread Spreadsheet::WriteExcel - Auto resizing of spreadsheet cells... by biswanath_c

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.