Excelize 2.10.1 Released - Open-source library for spreadsheet (Excel files)
Feb 25 · 5 min read · Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLAM / XLSM / XLSX / XLTM / XLTX files. Supports reading and writing spreadsheet document
Join discussionPython Excel Image Extraction: Automatically Save Embedded Pictures
Feb 14 · 7 min read · In everyday data processing tasks, we often encounter Excel files that contain a large number of images. Whether it’s product catalogs, employee records, or asset inventories, these images usually carry important visual information. However, when we ...
Join discussion
Building Styled Excel Reports from CSV Files Using Python Automation
Jan 28 · 9 min read · Raw data, often residing in CSV files, is the lifeblood of many organizations. However, presenting this data directly can be challenging. CSVs are excellent for data storage and interchange due to their simplicity, but they lack the visual structure ...
Join discussion
Create Dynamic Excel Reports with Python Conditional Formatting
Jan 14 · 8 min read · Manual conditional formatting in large Excel datasets can be a tedious, repetitive, and error-prone task. Imagine sifting through thousands of rows, manually applying rules to highlight critical data points, identify trends, or flag anomalies. This p...
Join discussion
Stop using Excel Macros. Here is how to use Python (Guide for Analysts) Subtitle: VBA is dying. It’s time to modernize your stack.
Jan 5 · 2 min read · Let's be honest. We have all been there. You spend 4 hours writing a VBA Macro to automate a weekly report. It works perfectly... until next Tuesday. Then you get the dreaded Runtime error '1004'. Why? Because someone added a new column, or changed t...
Join discussionWrite Python Lists to Excel with Formatting and Dates
Dec 30, 2025 · 5 min read · In today’s data-driven world, Python has become a go-to language for data processing and automation. A very common requirement in real-world applications is exporting processed data—especially data organized as Python lists—into Excel files for shari...
Join discussion
Python Techniques for Programmatic Creation of Excel Formulas
Dec 23, 2025 · 9 min read · Excel remains an indispensable tool for data management and analysis across countless industries. However, the manual entry of formulas, especially in large or frequently updated spreadsheets, is notoriously tedious, error-prone, and a significant dr...
Join discussion
A Complete Guide to Exporting Python Lists to Excel Efficiently
Dec 12, 2025 · 8 min read · The ability to efficiently export data from Python to Excel is a cornerstone of many data-driven workflows. Whether you're generating reports for stakeholders, archiving analytical results, or preparing structured datasets for business intelligence t...
Join discussion
Python XLSX Reader Guide
Jul 27, 2025 · 4 min read · Spreadsheets often store critical data that powers reports, dashboards, and data pipelines. Yet, when it comes to reading XLSX files with Python, developers sometimes overlook cell types like dates, formulas, and styles. How can you handle these vari...
Join discussion