Tagged articles

Excel automation

24 articles · Page 1 of 1

Aug 11, 2026 · Artificial Intelligence

Can AI Reliably Process Critical Data? A 10‑Minute End‑to‑End Test with Four Excel Tables

The author evaluates the Office Xiaoxuan AI assistant by feeding it 8,137 attendance records and three related business tables, then walks through file reading, data cleaning, cross‑table verification, and interactive dashboard generation, completing the entire workflow in about ten minutes while highlighting transparency, cost tracking, and verification limits.

AI data processingAI workflowExcel automation

0 likes · 9 min read

Can AI Reliably Process Critical Data? A 10‑Minute End‑to‑End Test with Four Excel Tables

Python Crawling & Data Mining

Jul 6, 2026 · Fundamentals

A Complete Python Solution for Converting Excel Numbers to Chinese Business Levels

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

A Complete Python Solution for Converting Excel Numbers to Chinese Business Levels

Old Zhang's AI Learning

Jul 3, 2026 · Artificial Intelligence

Why Codex’s Office Skills Are Seriously Underrated: Word, Excel, PPT, and PDF All Integrated into Workflows

The author demonstrates how OpenAI Codex can act as a full‑featured office assistant, using plugins to read PDFs, extract data into spreadsheets, draft Word documents, design PowerPoint presentations, and combine everything via Sites and annotations into a seamless, end‑to‑end workflow.

AI agentsExcel automationOpenAI Codex

0 likes · 8 min read

Why Codex’s Office Skills Are Seriously Underrated: Word, Excel, PPT, and PDF All Integrated into Workflows

Python Crawling & Data Mining

Jun 8, 2026 · Fundamentals

Python Automation: Merge Tens of Thousands of Records into a Single Excel Sheet with One Click

This article demonstrates how to use Python and pandas to automatically structure, clean, and combine tens of thousands of OCR‑generated data rows from multiple files into a single Excel workbook, eliminating manual copy‑paste and ensuring uniform fields and formats.

Excel automationOCR data processingPandas

0 likes · 4 min read

Python Automation: Merge Tens of Thousands of Records into a Single Excel Sheet with One Click

Test Development Learning Exchange

Mar 22, 2026 · Operations

Automate Jira Defect Cleaning: Python Script to Generate Smart Excel Reports

Learn how to set up a Python-based workflow that reads Jira export CSV files, cleans and enriches defect data, infers root causes, generates test suggestions, and outputs a formatted Excel workbook with data validation, dropdowns, and sensitive data masking, all configurable via YAML and JSON.

AutomationExcel automationJira

0 likes · 14 min read

Automate Jira Defect Cleaning: Python Script to Generate Smart Excel Reports

Python Programming Learning Circle

Nov 19, 2025 · Backend Development

Build a Reusable Python Batch Tool for Excel Automation

Learn how to create a modular Python script that batch processes Excel files—merging, cleaning, renaming, and more—using pandas and openpyxl, with a clear project structure and extensible design for real-world office automation.

Batch ProcessingExcel automationPandas

0 likes · 7 min read

Build a Reusable Python Batch Tool for Excel Automation

Model Perspective

Apr 1, 2025 · Fundamentals

Unlock Excel’s Power: A Complete Guide to Python in Excel

Python in Excel lets Microsoft 365 users write and run Python code directly within spreadsheets, offering built-in libraries for data analysis, visualization, and machine learning, with cloud execution, seamless cell integration, step‑by‑step activation, sample code, library support, data import, troubleshooting, and practical tips.

Data AnalysisExcel automationMatplotlib

0 likes · 12 min read

Unlock Excel’s Power: A Complete Guide to Python in Excel

Test Development Learning Exchange

Oct 17, 2024 · Operations

Python Scripts for Automating HR Recruitment Processes with Excel and Email

This guide demonstrates how HR recruiters can use Python and libraries such as pandas and openpyxl to create, read, modify, and manage Excel candidate data, perform filtering, grouping, charting, and automatically send interview notification emails, thereby streamlining recruitment workflows.

Email NotificationExcel automationHR recruitment

0 likes · 14 min read

Python Scripts for Automating HR Recruitment Processes with Excel and Email

Test Development Learning Exchange

Jun 30, 2024 · Fundamentals

Theoretical Part: Python and Excel Chart Automation

This article introduces how to automate Excel chart generation using Python libraries like pandas and openpyxl, enabling efficient data visualization and analysis.

Data AnalysisData VisualizationExcel automation

0 likes · 4 min read

Theoretical Part: Python and Excel Chart Automation

Python Crawling & Data Mining

Feb 27, 2024 · Fundamentals

Automate Multi‑Sheet Excel Scoring with Python & Pandas: Step‑by‑Step Guide

This article walks through using Python and pandas to batch‑process seven Excel evaluation sheets, skipping header rows, cleaning data, computing total and average scores per person, merging results, and outputting aggregated statistics, providing a practical automation solution for repetitive office tasks.

Batch ProcessingData ProcessingExcel automation

0 likes · 7 min read

Automate Multi‑Sheet Excel Scoring with Python & Pandas: Step‑by‑Step Guide

Python Crawling & Data Mining

Jan 10, 2024 · Fundamentals

Batch Insert Images into Excel Cells with Python and openpyxl

This article demonstrates how to use Python's openpyxl library to automatically insert named images into specific Excel cells in bulk, explaining the problem, providing a complete script, and offering practical tips for handling large files and sharing the solution with the community.

Batch ProcessingExcel automationPython

0 likes · 5 min read

Batch Insert Images into Excel Cells with Python and openpyxl

Python Programming Learning Circle

Aug 12, 2022 · Fundamentals

Automating Excel Reports with Python xlwings and pandas

This article demonstrates how to replace tedious manual Excel reporting by using Python libraries pandas and xlwings to read multiple sheets, merge data, write the combined DataFrame back to Excel, and apply conditional formatting such as font colors, borders, and cell shading based on statistical thresholds.

Data ProcessingExcel automationPandas

0 likes · 10 min read

Automating Excel Reports with Python xlwings and pandas

Python Programming Learning Circle

Mar 23, 2022 · Operations

Automating Excel Rental Statement Generation with Python, pandas, xlwings, and PyInstaller

This tutorial demonstrates how to split a master Excel rent ledger into per‑room Excel files, automatically adjust column widths and borders, capture each sheet as an image using xlwings and Pillow, and finally package the script into a standalone executable for distribution.

Excel automationPandasPyInstaller

0 likes · 9 min read

Automating Excel Rental Statement Generation with Python, pandas, xlwings, and PyInstaller

Python Crawling & Data Mining

Jan 22, 2022 · Fundamentals

Can Python Replace VBA? Master Excel Automation with xlwings

This article compares VBA and Python for Excel automation, explains why Python is called a glue language, introduces key Python packages like xlwings, demonstrates code examples for creating worksheets and charts, outlines xlwings features, and discusses its learning curve and recommended resources.

Excel automationScriptingVBA

0 likes · 8 min read

Can Python Replace VBA? Master Excel Automation with xlwings

Python Crawling & Data Mining

Jan 19, 2022 · Fundamentals

Master openpyxl: Automate Excel Tasks with Python in Minutes

This guide walks you through installing openpyxl, opening and creating workbooks, accessing sheets and cells, iterating over ranges, modifying data, applying styles, and saving Excel files using Python, complete with code examples and visual illustrations.

Data ProcessingExcel automationTutorial

0 likes · 9 min read

Master openpyxl: Automate Excel Tasks with Python in Minutes

MaGe Linux Operations

Sep 30, 2021 · Operations

Boost Your Productivity: Automate Excel with Python and xlwings

This guide demonstrates how to use Python's xlwings library to programmatically create, rename, list, print, and split Excel workbooks and worksheets, enabling batch processing and automation that significantly improves efficiency for repetitive spreadsheet tasks.

Batch ProcessingExcel automationScripting

0 likes · 5 min read

Boost Your Productivity: Automate Excel with Python and xlwings

Python Programming Learning Circle

Sep 3, 2021 · Fundamentals

Automating Excel with Python xlwings: Batch Create, Rename, Print, and Split Workbooks

This tutorial demonstrates how to use Python's xlwings library to programmatically create, save, list, rename, print, and split Excel workbooks and worksheets, providing practical code examples for automating common spreadsheet tasks and improving workflow efficiency.

Excel automationPythonScripting

0 likes · 5 min read

Automating Excel with Python xlwings: Batch Create, Rename, Print, and Split Workbooks

Python Crawling & Data Mining

May 7, 2021 · Fundamentals

Automate Excel Reporting with Python: A Step‑by‑Step Guide

This article walks you through automating daily loan reporting for a bank using Python and pandas, covering data loading, date filtering, table splitting, column renaming, concatenation, missing‑value handling, calculated fields, and pivot‑table generation to replace repetitive Excel tasks.

Excel automationPythonbank loans

0 likes · 13 min read

Automate Excel Reporting with Python: A Step‑by‑Step Guide

Python Crawling & Data Mining

Mar 4, 2021 · Fundamentals

Automate Excel Data Extraction with Python openpyxl: From Single to 1000 Files

This tutorial shows how to use Python's openpyxl (and optionally glob) to extract rows with purchase counts over 50 from an Excel sheet, create a new workbook, and scale the solution to batch‑process a thousand similar files automatically.

Batch ProcessingExcel automationPython

0 likes · 8 min read

Automate Excel Data Extraction with Python openpyxl: From Single to 1000 Files

Python Crawling & Data Mining

Feb 16, 2021 · Fundamentals

Excel Automation with Python xlwings: Install, Basics, and Code Samples

This guide introduces the xlwings library for Python, covering installation, core concepts, and detailed code examples for opening Excel, reading and writing cells, managing workbooks, handling ranges, formatting, formulas, and colors, helping you automate Excel tasks efficiently.

Excel automationPythoncode examples

0 likes · 9 min read

Excel Automation with Python xlwings: Install, Basics, and Code Samples

Python Crawling & Data Mining

Sep 5, 2020 · Fundamentals

How to Batch Extract and Filter Excel Data with Python’s openpyxl and glob

Learn how to use Python's openpyxl and glob modules to automatically extract rows with purchase quantities over 50 from single or thousands of Excel files, create new workbooks, and merge results, with complete code examples for both basic and advanced scenarios.

Batch ProcessingExcel automationPython

0 likes · 7 min read

How to Batch Extract and Filter Excel Data with Python’s openpyxl and glob

Python Crawling & Data Mining

Aug 29, 2020 · Backend Development

Automate Payroll Generation with Python: Step-by-Step Excel Script

Learn how to replace repetitive Excel payroll creation with a Python script that reads, copies, styles, and inserts rows, updates formulas, and outputs a ready-to-use payroll sheet, complete with full code examples and detailed explanations.

Excel automationPythonScript

0 likes · 7 min read

Automate Payroll Generation with Python: Step-by-Step Excel Script

Python Crawling & Data Mining

Apr 3, 2020 · Fundamentals

Automate Excel Data Cleaning with Python pandas: Step-by-Step Guide

This article demonstrates how to use Python's pandas library to read CSV and XLS files, filter and merge data based on group assignments, compute derived columns, and export the results to a new Excel workbook, providing a complete automation workflow for Excel data processing.

CSVData ProcessingExcel automation

0 likes · 6 min read

Automate Excel Data Cleaning with Python pandas: Step-by-Step Guide

Test Development Learning Exchange

Jun 19, 2018 · Big Data

Python Script for Excel Data Validation and Cross-Referencing

This article presents a Python script for validating and cross-referencing data between Excel files, particularly useful for big data testing scenarios where developers need to verify filtered data accuracy.

Excel automationPythonbig data testing

0 likes · 3 min read

Python Script for Excel Data Validation and Cross-Referencing