Python for Office

Question

i will be giving a weekend class python for office.
I think we do some pdf and ppt and introduce the module os.
I would like to get some ideas for useful progs and libraries.

Answer 1

I don't know if this ebook could help you: https://automatetheboringstuff.com

Maybe it could help to describe the normal tasks in your office.

Answer 2

PDF generation from HTML: this is the best library that i know of for this purpose

https://wkhtmltopdf.org/

https://pypi.org/project/pdfkit/

https://github.com/JazzCore/JUMP_LINK__&&__python__&&__JUMP_LINK-pdfkit

https://micropyramid.com/blog/how-to-create-pdf-files-in-python-using-pdfkit/

https://pythonexamples.org/python-convert-html-to-pdf/

Answer 3

Web scraping could also be a good topic, for example read fresh exchange rates or stock prices from a website every day.
Could even combine it with pandas, save it as excel and send it in email :)

Answer 4

https://code.sololearn.com/WBHiShj1ublU/?ref=app

See what's still working 🤣

Answer 5

You could check this ressource, but I think there are a lot of more.

https://www.xlwings.org/

Panda and sqlalchemy are useful todo.

Answer 6

I would like to see a course in GUI- and database-programming, preferably based on Tkinter and SQLite3, in order to create a knowledge-base. I often have the problem to find reports which I wrote years ago about a topic and when I now am dealing with a similar topic.

Answer 7

Excel integration is really easy with pandas, just need the right libraries installed.
pandas.read_excel()
DataFrame.to_excel()

https://www.dataquest.io/blog/excel-and-pandas/

Answer 8

Tibor Santa yes...
excel is a must have.
I am not familiar with pandas.
Didnt know it can excel...

Answer 9

Denise Roßberg
but so what from!
Fortunately it is in my bookshelf.

Answer 10

pandas library for reading and handling data, and exporting to excel (you can probably just scratch the surface but I think Excel is a must topic)

Answer 11

Besides pandas. You can easily handle lower level excel operations from python itself. Using xlrd package.

Answer 12

openpyxl baybeeee

Answer 13

Thanks

Answer 14

Whatever you choose, stress best practices and always document your code.

Answer 15

Yordam kere

Answer 16

You can make documentary for this for future use and enhancement

Answer 17

,
https://www.sololearn.com/discuss/2130604/?ref=app

Answer 18

Oma Falk
When and where?

Answer 19

Jan Markus if you continue to produce tkinter examples as by now and add sql, that would be it ;)

Answer 20

Hi