Outputting Python To Word Document

Asked Dec 01 '16 at 21:24

Active Dec 01 '16 at 21:24

Viewed 237 times

I've been following along in Automate the Boring Stuff.

This question follows my two previous questions here:

Iterate Dictionary in Python and Sum Totals by Category

I've been using the methods used in ATBS to print out some data from my python code to a word document. The following is a snippet of how this is setup:

dataFile = open('stocks.py', 'w')
wordFile = open('stocks.doc', 'w')
dataFile.write('allData = ' + pprint.pformat(stockData))

wordFile.write(pprint.pformat(sectors))

My question is two fold. First, i have a dictionary called 'sectors' that holds a key 'sector' with a 'percentage' value. I want to output this to a table in word like so:

Technology 30% Health Care 20% Financials 30%

but i'm not finding it easy via the pprint method. Is there a good way to do this?

my second question--is--is there a better way to be doing this? i know ATBS is sort of the beginners way of using python but i'm open to trying a better way of using python to analyze my data in excel and then generate an automated report in Word.

edited May 23 '17 at 12:01

Community

asked Dec 01 '16 at 21:24

John Rogerson

1,153
2
19
51

The [python-docx](https://python-docx.readthedocs.io/en/latest/) module is invaluable for this kind of thing. – Rick Dec 01 '16 at 21:30
i just tried using that and it didn't seem to be working--my thinking is that it might not be compatible with 3.5. do you know if that might be the case? – John Rogerson Dec 01 '16 at 21:45
If it's possible, downgrading your Python from 3.5 to 3.4 could solve your problem. – Philip Tzou Dec 01 '16 at 21:53
The docs say 3.4. – Rick Dec 01 '16 at 22:07

Outputting Python To Word Document

0 Answers0