Tag

#xlsx

17 posts1 followers

Explore Hashnode

Alternatives

John Scott9h ago · 9 min read

Installing ETCH in Oracle APEX in less than 5 minutes

Most of the APEX teams and companies I've worked with over the years have the same request sooner or later: the report on screen is fine, but can I have it as a Word document? Or Excel, PowerPoint or

get-etch.hashnode.dev

get-etch.app1d ago · 8 min read

Generate Word, Excel and PowerPoint documents from Python using ETCH

Using ETCH with Python to generate Word, Excel and PowerPoint documents is very straightforward. In this post we'll walk through the initial installation and some simple examples. Everything covered h

get-etch.hashnode.dev

get-etch.app4d ago · 7 min read

What is ETCH and how can it help?

You've probably seen a folder like this one. I've worked in plenty of places where it was normal. Every quarter, someone opens last quarter's deck, saves it under a new name, and spends a day pasting

get-etch.hashnode.dev

Thomas PortelangeMar 6 · 6 min read

Writing a Zero-Dependency CSV and XLSX Reader/Writer

Some projects start with a grand plan. Others start because you just need to read a file without thinking too much about it. That was the case for spread-compat. I needed a common interface for CSV, X

blog.lekoala.be

xuriFeb 25 · 5 min read

Excelize 2.10.1 Released - Open-source library for spreadsheet (Excel files)

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

xuri.hashnode.dev

Alex TaylorFeb 14 · 7 min read

Python Excel Image Extraction: Automatically Save Embedded Pictures

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 ...

allr.hashnode.dev

Alex TaylorJan 28 · 9 min read

Building Styled Excel Reports from CSV Files Using Python Automation

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 ...

allr.hashnode.dev

Alex TaylorJan 14 · 8 min read

Create Dynamic Excel Reports with Python Conditional Formatting

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...

allr.hashnode.dev

Data ArchitectJan 5 · 2 min read

Stop using Excel Macros. Here is how to use Python (Guide for Analysts) Subtitle: VBA is dying. It’s time to modernize your stack.

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...

spreadsheetsolver.hashnode.dev

Alex TaylorDec 30, 2025 · 5 min read

Write Python Lists to Excel with Formatting and Dates

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...

allr.hashnode.dev

Search Hashnode

Explore Hashnode

Trending tags this week

Installing ETCH in Oracle APEX in less than 5 minutes

Generate Word, Excel and PowerPoint documents from Python using ETCH

What is ETCH and how can it help?

Writing a Zero-Dependency CSV and XLSX Reader/Writer

Excelize 2.10.1 Released - Open-source library for spreadsheet (Excel files)

Python Excel Image Extraction: Automatically Save Embedded Pictures

Building Styled Excel Reports from CSV Files Using Python Automation

Create Dynamic Excel Reports with Python Conditional Formatting

Stop using Excel Macros. Here is how to use Python (Guide for Analysts) Subtitle: VBA is dying. It’s time to modernize your stack.

Write Python Lists to Excel with Formatting and Dates