I was wondering how one would go about adding borders to blocks of data within an excel column that have space above and below. I am able to output Excel workbook with data placed in columns without any problem. I am using Writer::Excel and can format the data using calls such as: 
      my $format_section = $workbook->add_format(
       
        font  => 'Arial',
        bold          => 1,
        size          => 8,
        pattern       => 1,
        border        => 0,
        color         => 'black',
        fg_color      => 'white',
        valign        =>  'top'
        
    );

[download]

If I turn on the border option, this will add the borders along all sides row-per-row as illustrated below:

 
data
data
 
data
data
 

What I need is to add borders around all sides excluding rows that do not have data. Here is an example:

data
data

data
data

Is there another module other than Writer::Excel that would help me to easily parse the contents of each column picking out the empty rows above and below each data set? Many thanks.

In reply to Adding Borders to Excel Data (Excel::Writer) by GuiPerl

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.