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

Whenever I create an Excel document with WriteExcel with the gui program I am working on, I get thin black lined borders between the cells and a bold black line around the whole worksheet when I view in print preview or print it. I can't seem to get rid of it at all. If I go to format>cells>border there is no borders applied (by the way the company I work for is still on excel 2000). I haven't figured out how to get rid of it once in excel either.

Any monk run into this problem yet and found a solution to the borders that just appear when you don't program them in and can't seem to get rid of them? If so, please share your knowledge

Thanks

Replies are listed 'Best First'.
Re: WriteExcel Gives Border By Default
by roboticus (Chancellor) on Nov 10, 2011 at 23:38 UTC

    amdme127:

    Perhaps you just need to call $worksheet->hide_gridlines(2);?

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]

      Thanks that worked perfectly. That was exactly what I needed

      I slightly modified it to this:

      $worksheet->hide_gridlines(1);

      I still wanted the gridlines in the excel file (I was probably a little unclear, my bad), I just didn't want to see them when I printed the file.

      Thanks again for the help. I keep trying to use set_border and other variants, but being gridlines and not a border makes things a bit more clear now

[reply]
[d/l]

Back to Seekers of Perl Wisdom