Office Automation

Python Programming Learning Circle

May 14, 2022 · Fundamentals

Using Python to Automate Excel, Word, and PowerPoint in Office Work

This article explains how Python can boost office productivity by using libraries such as xlrd/xlwt, openpyxl, pandas for Excel, python‑docx for Word, and python‑pptx for PowerPoint, highlighting their ease of use and efficiency in handling large or repetitive documents.

ExcelOffice AutomationPython

0 likes · 3 min read

Using Python to Automate Excel, Word, and PowerPoint in Office Work

Python Programming Learning Circle

Jul 8, 2021 · Operations

Python Office Automation Techniques: Document Conversion, Geocoding, Distance Calculation, Batch File Processing, and Outlook Email Automation

This article presents a collection of Python scripts for office automation, covering Word doc‑to‑docx conversion, batch address geocoding using Baidu API, distance computation with geopy, coordinate conversion between Baidu and Gaode, Excel merging, Word‑to‑PDF conversion, extracting tables from Word, and bulk Outlook email sending.

File ConversionOffice AutomationPython

0 likes · 11 min read

Python Office Automation Techniques: Document Conversion, Geocoding, Distance Calculation, Batch File Processing, and Outlook Email Automation