1 views collected around this technical thread.
This article provides a curated set of Python scripts that automate common batch tasks—including merging Excel and CSV files, renaming and moving files, PDF merging, image conversion and processing, QR‑code and word‑cloud generation, holiday marking, and bulk email sending—complete with ready‑to‑run code examples.
This comprehensive guide demonstrates how to read, write, modify, and format Excel, Word, and CSV files in Python using libraries such as xlrd/xlwt/xlutils for Excel, python-docx for Word, and the built‑in csv module, complete with code examples and feature comparison tables.
This article introduces the pdf2docx Python library for converting PDF files to DOCX, detailing its capabilities such as layout, paragraph, image, and table parsing, outlining current limitations, providing installation instructions, and showing a concise code example for practical use.
The article explains why Apache POI loads entire .xlsx zip files into memory causing OOM, demonstrates the issue with code examples, and shows how switching to EasyExcel's streaming read dramatically reduces memory usage while handling large Excel files in Java.