Python for Office | SoloLearn: Learn to code for FREE!

+30

Python for Office

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.

1/12/2020 10:51:41 AM

Oma Falk

32 Answers

New Answer

+23

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.

+18

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/python-pdfkit https://micropyramid.com/blog/how-to-create-pdf-files-in-python-using-pdfkit/ https://pythonexamples.org/python-convert-html-to-pdf/

+9

WhyFry I have a whole bunch of ideas what would be helpful apps which I could do with Python, Tkinter and SQLite. Among them are: - To-Do-List - Address-Book - Bookmarks for websites and descriptions - Dictionaries for abbreviations or vocabularies of different languages - Shopping lists - List of books - Tagging of photos - Scheduler and appointment reminder - a kind of private wikipedia - a simple image processing program - idea collection - assistand for taking notes when learning new topics, e.g. programming languages - ... The list could get longer, but I have to depart now to my yoga lesson.

+8

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 :)

+8

https://code.sololearn.com/WBHiShj1ublU/?ref=app See what's still working 🤣

+6

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

+6

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/

+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.

+6

You could check this ressource, but I think there are a lot of more. https://www.xlwings.org/ Panda and sqlalchemy are useful todo.

+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.

+4

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

+4

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)

+4

Sasha Djekic I will do my best!👍😁

+3

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

+1

openpyxl baybeeee

+1

Thanks

+1

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

+1

Yordam kere

+1

You can make documentary for this for future use and enhancement

0

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