Tagged articles
win32com
10 articles · Page 1 of 1
The article explains a real‑world requirement to map numeric business levels to Chinese strings in Excel and provides two Python solutions—one using openpyxl for modern .xlsx files and another using win32com for legacy .xls files—complete with runnable code and execution results.
Excel AutomationPythondata conversion
0 likes · 8 min read

This article walks through a fan‑requested Python automation that replaces artistic watermark text in shipping‑bill DOCX files, detailing the initial python‑docx attempt, the shortcomings of win32com shape traversal, and the final reliable solution using zipfile‑based XML replacement.
DOCXPythonText Replacement
0 likes · 10 min read

This guide demonstrates how to create a Python script that uses the win32com library to batch convert Word (.doc/.docx) files to PDF on Windows, including code examples, handling of Office/WPS detection, folder management, common pitfalls, and packaging the script into an executable.
PDFPythonScript
0 likes · 10 min read

This tutorial demonstrates how to use Python libraries such as win32com and python-pptx to automate PowerPoint creation, manipulation, and styling—including copying templates, adding slides, text boxes, tables, charts, shapes, and images—while also covering seaborn installation and basic data‑visualization examples that can be embedded into PPT files.
PPT AutomationPythonSeaborn
0 likes · 24 min read

This tutorial demonstrates how to automate PowerPoint creation, modification, and data extraction with Python libraries such as win32com and python-pptx, and how to generate and embed data visualizations using seaborn, providing complete code examples for slides, tables, charts, shapes, and images.
PowerPoint automationSeabornpython-pptx
0 likes · 26 min read

This tutorial walks through setting up a Python environment, installing libraries, creating and editing Word documents with python-docx, converting files and generating PDFs using win32com, extracting Excel data with xlrd, visualizing scores with matplotlib, and automating batch document generation with docx-mailmerge.
Pythonautomationpython-docx
0 likes · 19 min read

This guide explains how to handle mixed .doc and .docx files by installing the win32com library, providing step‑by‑step code to batch convert .doc documents to .docx format and then process them with python‑docx for automated office workflows.
DOCXOfficebatch-processing
0 likes · 4 min read

This article explains how to use Python and the win32com library to automate the conversion of Excel .xls files (including .xlsm) to .xlsx format, covering essential libraries, FileFormat codes, and a complete code example with detailed explanations.
File ConversionPythonwin32com
0 likes · 4 min read

This tutorial demonstrates how to use Python's win32com library to control Microsoft Word via its COM object model, covering installation, creating and opening documents, manipulating selections and ranges, and applying page layout and style settings to meet official formatting standards.
COMPythonWord Automation
0 likes · 10 min read

This tutorial explains how to use Python's win32com library to control Microsoft Word, covering installation, creating and displaying documents, working with Selection, Range, Font, ParagraphFormat, PageSetup and Styles objects, and providing a complete example that formats a document to meet national standards.
COMDocument ProcessingPython automation
0 likes · 14 min read
