Excel::Writer::XLSX add borders where columns have already been defined

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

Have multiple column attributes such as text center, left, colors, etc. But want to do a write_row and have it but borders around each cell. Tried defining a column attribute to have a border but that created an infinite number of cells with borders for that column I do know the UL and LR cell

Comment on Excel::Writer::XLSX add borders where columns have already been defined

Replies are listed 'Best First'.
Re: Excel::Writer::XLSX add borders where columns have already been defined by soonix (Chancellor) on Oct 17, 2015 at 05:56 UTC
Tried defining a column attribute to have a border but that created an infinite number of cells with borders From my experience, that's the same what Excel does, (well, not an infinite number, but 65536 or 1048576 rows, depending on version) resulting in Megabyte-sized files for just a few hundred numbers … You'll have to define these attributes on the cell level.	[reply]
Re: Excel::Writer::XLSX add borders where columns have already been defined by Laurent_R (Canon) on Oct 16, 2015 at 16:25 UTC
It is a bit difficult to understand. Can you please show the code you have been using (please between `<code>` and `</code>` tags), at least it should help clarify what you've been doing, and perhaps also what you were intending to do.	[reply] [d/l] [select]