The Boring Python Office Talk
[Pages:32]The Boring Python Office Talk
Europython 2018 Edinburgh, Stefan Baerisch
1
Motivation
all images used as part of FreePics subscription
Some things should be boring
2
The Challenge
!
?Excel, Powerpoint, Word and PDF are
everywhere
?They are useful, but can be a lot of effort
to produce by hand
?Python has modules to automate a lot
of document creation
3
What you should get from this Talk
This Talk
Your Part
Awareness of great Python
Modules
Some Pointers
Sample Code
Your Tasks
Great Modules
Some Work
4
What you should get from this Talk
Perfectionist
I have no time !
We'll start simple
Pragmatist
5
Things we want Python to do.
1
Combine Information from multiple existing Excel Files
2
Add the table and chart from the result
file to a Power Point Presentation
3
Create a PDF for Archiving
6
Modules Used pandas
Used to combine inputs and produce pivot table
XlsxWriter
Used to create the Excel with charts, etc.
pdfrw
Used to combine PDF files
reportlab
Can create custom PDFs. Not really used
openpyxl
Can also read / change Excel Files. See Github
In headless mode. Can "print" to PDF
python-pptx
Used to change and Create PPTX files
PandasToPowerpoint
python-docx
So many modules...
You do not need much from each to begin with
7
Overall Program Flow
1
2
3
This is an example. You do not need pandas, you can use just Python. You can create text-heavy PPTXs without tables and charts, but with nice images...
8
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- the talk deals and steals
- the talk deals this week
- nv state board of cosmetology ce hours
- the talk show daytime deals
- safety talk on the flu
- certificate of attestation of exemption ce 200
- list of daytime talk shows
- board of cosmetology mn ce hours professional practice course
- ted talk the golden circle
- example of sales talk script
- the talk shop daily deals
- the talk today on deal