Re: Automated Unattended Convert spoolfile to Excel and emailed as an attachement

On Fri, Feb 13, 2015 at 9:36 AM, <rob@xxxxxxxxx> wrote:

For example I have this report:
Size Size Growth Growth
Directory mm/dd/yy mm/dd/yy Actual %

I will say, your choice of column header formats often change. For
example line one and line two could have been inverted but when you think
of sorting by column name versus column number you like this way better.

Forgive me if I'm diving too deep into this, but once you are fully
immersed in "the Excel way of thinking about reports", what you
*really* choose for column headings (in tables as simple as what
you've presented here) is to not split your headings into multiple
rows in the first place. Remember, a row in Excel can have arbitrary
height. Just make the first row taller (enough to fit two lines of
text, in your case).

Most Excel-writing libraries (including POI and the Python packages
mentioned in this thread) make it quite easy to set row heights and
column widths. Also, if your needs start to get fancy, you can merge
cells, center either vertically or horizontally, etc.

John Y.