Tagged articles
openpyxl
69 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 hands-on tutorial walks absolute beginners through Python installation on Windows, essential tools (IDLE, PyCharm, Jupyter), core syntax including data types, conditionals, loops, and functions, plus three practical projects: data visualization with pandas and matplotlib, a tax calculator script, and batch Excel processing with openpyxl.
Beginner TutorialExcel processingPandas
0 likes · 9 min read

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.
Excel AutomationPandasPython
0 likes · 7 min read

This guide explains how to combine a master XLS file with a detailed XLSX file by matching the "Name" column, handling non‑standard headers, skipping index columns, inserting new fields at a specific position, and exporting the merged result using Python, pandas, xlrd, and openpyxl.
ExcelPandasdata-merge
0 likes · 8 min read

This article explains how Python can efficiently read and write both XLS and XLSX Excel files using built‑in modules xlrd/xlwt and the third‑party openpyxl library, provides six reusable functions for common operations, and demonstrates testing procedures to verify correct data handling.
Pythondata-processingfile-io
0 likes · 10 min read

This tutorial explains the core concepts of openpyxl—including workbooks, sheets, and cells—demonstrates how to create, open, read, write, style, merge, and manipulate Excel files with Python, and provides complete code examples for generating 2D and 3D charts.
DataProcessingExcelSpreadsheet
0 likes · 11 min read

This article provides a step‑by‑step guide on installing the openpyxl library, creating new Excel workbooks, reading existing files, applying common operations such as iterating cells, modifying values, styling, merging, freezing panes, adding formulas, adjusting dimensions, and demonstrates practical scenarios including bulk data writes and pandas integration.
PandasPythondata processing
0 likes · 5 min read

Learn a collection of Python scripts that automate common Excel operations—including merging multiple files, find‑and‑replace, filtering rows, adding formulas, adjusting formats, extracting images, and encrypting workbooks—providing step‑by‑step code examples for efficient data processing.
DataProcessingExcelPandas
0 likes · 20 min read

This article introduces five widely used Python libraries—Pandas, OpenPyXL, XlsxWriter, Tablib, and Dask—detailing their installation commands, core features for handling structured and large‑scale data, and practical code examples for reading, writing, and processing Excel and CSV files.
ExcelPythondask
0 likes · 8 min read

This guide demonstrates how to install pandas and openpyxl, then use Python to read, merge, batch‑process, extract, clean, rename sheets, export to CSV, and analyze data across multiple Excel files, providing complete code examples for each task.
Excelautomationdata processing
0 likes · 12 min read

This guide introduces and compares several Python libraries—including csv, openpyxl, pandas, xlsxwriter, pyexcel, xlrd/xlwt, xlutils, tablib, ezodf, xlwings, and readxl—detailing their purposes, key features, typical use cases, installation commands, and example code for reading and writing CSV and Excel files.
Exceldata-processingopenpyxl
0 likes · 21 min read

This step‑by‑step guide shows how to generate a sample Excel file and then use pandas and openpyxl to read, write, update, filter, sort, group, format, chart, and finally save Excel workbooks, covering twenty essential operations for data automation.
ExcelPandasPython
0 likes · 12 min read

This article shows how to turn a Python list with many elements into the first column of an Excel sheet by presenting two practical solutions—one using openpyxl and another leveraging pandas—complete with code examples and step‑by‑step explanations.
ExcelPythonlist to column
0 likes · 5 min read

This article explains how to use Python's openpyxl and pandas libraries to read, write, style, and merge Excel files, covering installation, basic operations, advanced cell formatting, data manipulation, and techniques for combining multiple sheets or workbooks into a single DataFrame.
Exceldata-processingopenpyxl
0 likes · 9 min read

This guide demonstrates how to install pandas and openpyxl, create DataFrames, write them to Excel worksheets, merge cells, combine multiple DataFrames into separate sheets, merge multiple Excel files, apply styles and conditional formatting, and remove duplicate rows using Python.
Pythondata mergingopenpyxl
0 likes · 8 min read

This article walks through a common PermissionError encountered when using pandas and openpyxl to write to an Excel file, explains why it occurs, and provides a concise code solution that safely appends data without keeping the file open.
data-processingopenpyxlpermissionerror
0 likes · 4 min read

This article explains a Python‑based solution for splitting an Excel workbook into multiple files based on a column, preserving original formatting and inserting a summary sheet using pandas for data handling and openpyxl for format‑aware operations.
data-processingopenpyxl
0 likes · 4 min read

This tutorial demonstrates how to use Python's openpyxl library to apply fonts, borders, fills, alignments, number formats, conditional formatting, merged cells, dimensions, hyperlinks, and combined styles to Excel worksheets, providing full example code for each feature.
ExcelStylingTutorial
0 likes · 7 min read

This tutorial demonstrates how to use Python libraries such as pandas, matplotlib, openpyxl, and python-docx to load, clean, analyze, visualize, and automatically generate Excel and Word reports from CSV data, complete with code examples for each step.
Data ReportingPandasmatplotlib
0 likes · 6 min read

This guide demonstrates how to use Python's openpyxl and pandas libraries to automatically sort Excel columns by sales amount, filter rows exceeding a threshold, and extend functionality with regex, providing complete code examples for efficient data processing.
ExcelPandasdata-processing
0 likes · 7 min read

This article introduces how to automate Excel chart generation using Python libraries like pandas and openpyxl, enabling efficient data visualization and analysis.
Excel AutomationPandasPython
0 likes · 4 min read

This guide presents ten practical Python scripts that cover installing required libraries, reading and writing Excel files, merging sheets, cleaning and filtering data, creating pivot tables, generating charts, styling cells, and automatically emailing Excel reports, providing a complete workflow for Excel automation.
ExcelPandasdata-analysis
0 likes · 6 min read

This article walks through a common Python web‑scraping issue where data from multiple pages is overwritten, explains the root cause, and provides a complete, runnable script using requests, parsel, and openpyxl to correctly collect and store each page's information.
data-extractionopenpyxlrequests
0 likes · 6 min read

This article walks through a common issue where pandas cannot read encrypted Excel files, explains why a password is required, and provides a concise openpyxl‑based code snippet to load such files into a pandas DataFrame for further processing.
data-processingopenpyxl
0 likes · 5 min read

This article walks through handling merged headers and formula cells in Excel using Python's pandas and openpyxl, providing step‑by‑step code to merge multiple workbooks, skip unwanted rows, assign custom headers, and format the final sheet with merged cells.
ExcelPythondata processing
0 likes · 7 min read

This tutorial explains how to perform data‑driven testing by installing Playwright, reading test data from Excel with openpyxl, simulating user actions, and writing reusable unittest test cases that drive browser interactions based on external data.
PlaywrightPythonautomation
0 likes · 3 min read

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.
Excel AutomationPythonbatch processing
0 likes · 5 min read

This article introduces Python's xlwt, xlrd, and openpyxl libraries for Excel data processing, explains how to install them, and provides step‑by‑step code examples for writing and reading .xls and .xlsx files, making it a practical guide for data‑handling tasks.
ExcelPythondata-processing
0 likes · 8 min read

This article introduces Python's capabilities for handling Excel files, explains the differences between xls and xlsx formats, demonstrates using xlrd/xlwt for xls and openpyxl for xlsx, and provides six utility functions for reading, writing, and appending data, complete with test results.
File I/Oopenpyxlxlrd
0 likes · 11 min read

This article walks through a Python‑based solution for automating Excel tasks, explaining the problems in a fan's original script, presenting a corrected implementation with pandas and openpyxl, and offering an optimized version with detailed code snippets and explanations.
Pandasautomationopenpyxl
0 likes · 6 min read

This article walks through a Python automation task that processes Excel files to extract vulnerability data, explains the required code using openpyxl, shows before-and-after results, and highlights limitations for larger datasets, inviting readers to explore a pandas-based solution next.
Tutorialopenpyxl
0 likes · 6 min read

This tutorial walks through automating Excel-based vulnerability reporting with Python, explaining how to read, categorize, and write IP address data using openpyxl, and provides complete code and sample results to help readers implement the solution in their own workflows.
openpyxl
0 likes · 6 min read

This article walks through a real‑world Python automation task, showing how to read, filter, and update specific rows in an Excel workbook using openpyxl, complete with code examples and practical tips for extending the solution.
openpyxl
0 likes · 7 min read

This tutorial demonstrates how to use the Python openpyxl library to create, open, edit, and save Excel workbooks, covering worksheets, cells, ranges, formulas, merging, iteration, and file handling for both small and large spreadsheets.
Spreadsheetdata processingopenpyxl
0 likes · 6 min read

This article walks through a Python‑openpyxl issue where deleting rows leaves blank gaps, explains why row indices may not shift, provides a working code snippet, notes version‑specific behavior, and shares community tips to reliably clean up large Excel sheets.
ExcelPythondelete_rows
0 likes · 6 min read

This article walks through a Python automation example that uses the os module to collect subfolder names from a specified directory and the openpyxl library to write those names into an Excel workbook, providing full code and explanations.
OS moduleautomationfile-system
0 likes · 4 min read

This guide shows how to use Python libraries such as docx, jieba, NLTK, and openpyxl to read a Word file, perform tokenization, compute word frequencies, assign part‑of‑speech tags, and export the results into an Excel spreadsheet, including troubleshooting tips for common errors.
NLPNLTKWord
0 likes · 7 min read

This tutorial explains how to read and write Excel files in Python using xlrd/xlwt for .xls, openpyxl for .xlsx, and pandas for high‑level data handling, including installation commands, code examples, and a practical case of processing a tab‑separated car‑listing file.
ExcelPandasPython
0 likes · 6 min read

This article provides a detailed, step‑by‑step tutorial on using various Python libraries—including xlrd, xlwt, xlutils, xlwings, openpyxl, XlsxWriter, win32com, and pandas—to read, write, modify, and visualize Excel files, complete with installation commands, code examples, and practical tips for data handling and chart generation.
DataProcessingPandasopenpyxl
0 likes · 39 min read

This article walks through automating the aggregation of multiple Excel sheets using Python, presenting two practical solutions—one with openpyxl and another with pandas—complete with code snippets, explanations, and a final tip for sorting results by score.
Pandasautomationdata processing
0 likes · 4 min read

This article demonstrates how to use Python's openpyxl library to automatically copy and replace data across multiple Excel files, providing both single‑file and batch processing code examples that save time for repetitive spreadsheet tasks.
batch processingopenpyxl
0 likes · 5 min read

This tutorial explains how to use Python's xlrd, xlwt, and openpyxl libraries to read, write, and append data in both XLS and XLSX Excel formats, providing complete code examples, performance considerations, and test results for each operation.
data processingfile-ioopenpyxl
0 likes · 11 min read

This article walks through extracting quiz questions, options, and answers from a Word document using Python, demonstrating why the original regex failed and providing three refined solutions with regular expressions, openpyxl, and pandas for reliable automation.
automationopenpyxlregex
0 likes · 7 min read

This article provides a comprehensive guide to using the openpyxl library for creating, opening, editing, and saving Excel workbooks in Python, covering worksheet management, cell operations, merging, iteration, and efficient handling of large files with code examples.
data processingopenpyxlworkbook
0 likes · 8 min read

This tutorial demonstrates how to use the Python openpyxl library to create, open, modify, and save Excel workbooks, covering worksheet management, cell operations, row and column handling, insertion and deletion, as well as read‑only and streaming techniques for efficient data processing.
Excelautomationdata-processing
0 likes · 7 min read

This article walks through two practical methods for converting a Python list into the first column of an Excel file—first using openpyxl for direct cell writing, then leveraging pandas for a more concise DataFrame approach, plus additional pandas tricks for column manipulation.
PandasPythondata processing
0 likes · 5 min read

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.
Excel AutomationTutorialdata processing
0 likes · 9 min read

This article demonstrates how to use Python with pandas and openpyxl to automatically generate yearly Excel workbooks, create monthly sheets, and add predefined column headers, turning a manual multi‑minute task into a fast, error‑free process.
PandasPythonopenpyxl
0 likes · 5 min read

This article walks you through the complete process of automating Excel report generation with Python, covering Excel fundamentals, a five‑step workflow, practical code examples using pandas and openpyxl, and techniques for merging results into a single workbook or multiple sheets.
PandasPythondata processing
0 likes · 20 min read

This article explains how to use Python and the openpyxl library to automatically locate rows where column A equals 10 (representing 10 am) across multiple Excel files, presents two practical solutions, and provides complete code snippets and screenshots for easy implementation.
PandasPythonautomation
0 likes · 6 min read

This tutorial demonstrates how to use Python's Pillow library for image manipulation, openpyxl for Excel spreadsheet handling, and python-docx for creating and editing Word documents, providing code examples for common operations such as cropping, resizing, filtering, and data insertion.
ExcelWordimage-processing
0 likes · 7 min read

Learn how to efficiently create, open, edit, and save Excel workbooks using Python’s openpyxl library, covering worksheet management, cell operations, merging, formatting, formulas, row/column iteration, and value-only extraction, with practical code examples for both small and large files.
Excelautomationcell operations
0 likes · 8 min read

This article provides a detailed tutorial on using various Python libraries such as xlrd, xlwt, xlutils, xlwings, openpyxl, XlsxWriter, win32com, and pandas for reading, writing, modifying, and visualizing Excel files, complete with code examples and best‑practice tips.
ExcelPandasautomation
0 likes · 38 min read

This tutorial introduces Python's openpyxl library for reading, writing, and manipulating Excel files, covering installation, basic methods, and four practical examples including creating multiplication tables, inserting rows, transposing data, and importing text files into spreadsheets.
Excelautomationdata-processing
0 likes · 6 min read

This guide shows how to use Python, openpyxl, and yagmail to automatically read department bonus Excel files and email each manager their report, while also sending individual employees personalized bonus details, streamlining a tedious manual process into a few lines of code.
BackendExcelKeyring
0 likes · 7 min read

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.
Excel AutomationPythonbatch processing
0 likes · 8 min read

This tutorial shows how to use Python's glob, python-docx, and openpyxl libraries to automatically scan a folder of Word meeting notices, pull out study time, content, format, and host information, and populate an Excel spreadsheet, saving hours of manual work.
PythonWordautomation
0 likes · 8 min read

This article explains how to export massive amounts of data from Python to Excel by installing openpyxl, providing complete code examples for reading and writing both .xlsx and .xls files, comparing xlrd/xlwt with openpyxl, and recommending the best approach for large‑scale data export.
BackendCSVExcel
0 likes · 10 min read

This guide walks you through preparing data with Pandas, saving it to Excel using direct to_excel, ExcelWriter with custom date and number formats, applying styles via Pandas Styler, leveraging both xlsxwriter and openpyxl engines for advanced formatting, auto‑adjusting column widths, and using templates for reusable layouts, all illustrated with code snippets and screenshots.
ExcelStylingdata export
0 likes · 22 min read

This tutorial walks you through installing openpyxl, understanding Excel's workbook‑sheet‑cell hierarchy, and provides step‑by‑step code examples for reading, writing, styling, and manipulating Excel files using Python, serving as a handy reference for developers.
ExcelPythonautomation
0 likes · 7 min read

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.
Excel AutomationPythonbatch processing
0 likes · 7 min read

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 AutomationPayrollPython
0 likes · 7 min read

This tutorial walks through a real‑world Python office‑automation task: extracting rows for a specific archive name from dozens of Excel worksheets and consolidating them into a new workbook, complete with step‑by‑step analysis and full code examples.
data-processingopenpyxlscripting
0 likes · 7 min read

This tutorial shows how to use Python's openpyxl and python-docx libraries to read company data from an Excel sheet, replace placeholder tags in a Word contract template, and automatically generate individualized contracts for each company in a batch process.
ExcelPythonWord
0 likes · 9 min read

This article walks through using Python to read and process data from an Excel file, generate a structured filename, convert legacy .doc files to .docx, and automatically populate a Word document’s tables, providing a complete automation workflow for reporting tasks.
openpyxlpython-docx
0 likes · 9 min read

This guide demonstrates how to programmatically pull date, title, and document number fields from thousands of similarly structured Word tables, normalize the dates, and export the data into a formatted Excel spreadsheet using Python's docx, datetime, and openpyxl libraries.
DOCXExcelPython
0 likes · 6 min read

This article demonstrates how to use Python (with pandas and openpyxl) to efficiently clean Excel worksheets by removing duplicate and empty rows, stripping spaces, reformatting dates, and formatting numeric values with proper precision and currency symbols.
Excelopenpyxl
0 likes · 9 min read

This guide demonstrates how to quickly build Python-based HTTP/HTTPS API automation test scripts using requests for sending requests, pandas for handling test case data, and openpyxl for exporting results to Excel, covering request construction, response handling, data comparison, and result styling.
Pandasapi-testingopenpyxl
0 likes · 7 min read

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
