BestHub
Sign in
Tagged articles

Excel automation

25 articles · Page 1 of 1
Old Zhang's AI Learning
Old Zhang's AI Learning
Sep 16, 2026 · Artificial Intelligence

Doubao Work Desktop Review: Two Weeks Without Office or WPS

The author details a two-week hands-on test of Doubao Work's desktop client, demonstrating how its integrated AI capabilities for PDF processing, Word editing, Excel formulas, PPT generation, and customizable skills replaced traditional Office/WPS workflows, including setup tips, feature walkthroughs, and a format-matching skill for template compliance.

AI office toolsAI productivityDoubao Work
0 likes · 11 min read
Doubao Work Desktop Review: Two Weeks Without Office or WPS
Wuming AI
Wuming AI
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
Old Zhang's AI Learning
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 automationOffice Automation
0 likes · 8 min read
Why Codex’s Office Skills Are Seriously Underrated: Word, Excel, PPT, and PDF All Integrated into Workflows
Model Perspective
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 automationPython in Excel
0 likes · 12 min read
Unlock Excel’s Power: A Complete Guide to Python in Excel
Python Crawling & Data Mining
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 ProcessingExcel automationPython
0 likes · 7 min read
Automate Multi‑Sheet Excel Scoring with Python & Pandas: Step‑by‑Step Guide
Python Crawling & Data Mining
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
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.

Excel automationPythondata processing
0 likes · 10 min read
Automating Excel Reports with Python xlwings and pandas
Python Crawling & Data Mining
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 automationVBAscripting
0 likes · 8 min read
Can Python Replace VBA? Master Excel Automation with xlwings
MaGe Linux Operations
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 Crawling & Data Mining
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