If you hit openpyxl over the head with enough Claude Code tokens, you too can automate all of your chart builds into a single python file.
Warning: it's going to be a LOT of tokens.
Warning: it's going to be a LOT of tokens.
February 4, 2026 at 1:53 AM
If you hit openpyxl over the head with enough Claude Code tokens, you too can automate all of your chart builds into a single python file.
Warning: it's going to be a LOT of tokens.
Warning: it's going to be a LOT of tokens.
Working With Excel Files in Python Using openpyxl
AUTOMATING EXCEL WITH PYTHON - pythonclcoding.gumroad.com/l/gqrlq
AUTOMATING EXCEL WITH PYTHON - pythonclcoding.gumroad.com/l/gqrlq
December 13, 2025 at 4:56 AM
Working With Excel Files in Python Using openpyxl
AUTOMATING EXCEL WITH PYTHON - pythonclcoding.gumroad.com/l/gqrlq
AUTOMATING EXCEL WITH PYTHON - pythonclcoding.gumroad.com/l/gqrlq
Excel, CSV, PDF:
Pandas: pandas.pydata.org
Openpyxl: openpyxl.readthedocs.io/en/stable/
PyPDF: github.com/py-pdf/pypdf
Textract: github.com/deanmalmgren...
XlsxWriter: github.com/jmcnamara/Xl...
pyxlsb: github.com/willtrnr/pyx...
pylightxl: github.com/PydPiper/pyl...
Pandas: pandas.pydata.org
Openpyxl: openpyxl.readthedocs.io/en/stable/
PyPDF: github.com/py-pdf/pypdf
Textract: github.com/deanmalmgren...
XlsxWriter: github.com/jmcnamara/Xl...
pyxlsb: github.com/willtrnr/pyx...
pylightxl: github.com/PydPiper/pyl...
March 6, 2025 at 2:45 PM
Excel, CSV, PDF:
Pandas: pandas.pydata.org
Openpyxl: openpyxl.readthedocs.io/en/stable/
PyPDF: github.com/py-pdf/pypdf
Textract: github.com/deanmalmgren...
XlsxWriter: github.com/jmcnamara/Xl...
pyxlsb: github.com/willtrnr/pyx...
pylightxl: github.com/PydPiper/pyl...
Pandas: pandas.pydata.org
Openpyxl: openpyxl.readthedocs.io/en/stable/
PyPDF: github.com/py-pdf/pypdf
Textract: github.com/deanmalmgren...
XlsxWriter: github.com/jmcnamara/Xl...
pyxlsb: github.com/willtrnr/pyx...
pylightxl: github.com/PydPiper/pyl...
im archiving terabytes of gov data today, but also looping through every .xlsx with openpyxl to convert their styles to Comic Sans. this maintains my net-zero karma policy #databs
February 1, 2025 at 2:54 AM
im archiving terabytes of gov data today, but also looping through every .xlsx with openpyxl to convert their styles to Comic Sans. this maintains my net-zero karma policy #databs
FINALLY, DEATH TO OPENPYXL
November 21, 2024 at 6:39 PM
FINALLY, DEATH TO OPENPYXL
New tool added to our directory: Paper Office
New tool: Paper Office
Paper Office is a suite of agent-first forks of python-docx, python-pptx, and openpyxl. Each package keeps the familiar import name and expands the API.
www.llmrelevance.com
September 24, 2026 at 1:09 AM
New tool added to our directory: Paper Office
Processing #Excel sheets with Python is an everyday use case for many and can boost office efficiency. This Python Land article teaches you how to create, read, update, and delete data in Excel files using #Python
python.land/data-process...
python.land/data-process...
How to Process Excel Data in Python and Pandas • Python Land Tutorial
This article shows how to create and read Excel files in Python using the pandas, xlsxwriter, and openpyxl modules.
python.land
November 12, 2024 at 9:14 AM
Processing #Excel sheets with Python is an everyday use case for many and can boost office efficiency. This Python Land article teaches you how to create, read, update, and delete data in Excel files using #Python
python.land/data-process...
python.land/data-process...
🐍📰 A Guide to Excel Spreadsheets in Python With openpyxl
In this step-by-step tutorial, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets,and so much more.
#python
In this step-by-step tutorial, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets,and so much more.
#python
A Guide to Excel Spreadsheets in Python With openpyxl
In this step-by-step tutorial, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets, extract information from spreadsheets, create simple or more complex spreadsheets, including...
realpython.com
June 11, 2025 at 10:30 PM
🐍📰 A Guide to Excel Spreadsheets in Python With openpyxl
In this step-by-step tutorial, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets,and so much more.
#python
In this step-by-step tutorial, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets,and so much more.
#python
openpyxl -> calamine for reading excel
Data pipeline runs 95% faster.
Over 18 minutes to 1 and change
Rust ftw
Data pipeline runs 95% faster.
Over 18 minutes to 1 and change
Rust ftw
September 19, 2025 at 6:54 PM
openpyxl -> calamine for reading excel
Data pipeline runs 95% faster.
Over 18 minutes to 1 and change
Rust ftw
Data pipeline runs 95% faster.
Over 18 minutes to 1 and change
Rust ftw
Automating Excel with Python [by Michael Driscoll]
driscollis.gumroad.com/l/openpyxl?a...
#javascript #websitedevelopment
driscollis.gumroad.com/l/openpyxl?a...
#javascript #websitedevelopment
July 28, 2025 at 4:30 AM
Automating Excel with Python [by Michael Driscoll]
driscollis.gumroad.com/l/openpyxl?a...
#javascript #websitedevelopment
driscollis.gumroad.com/l/openpyxl?a...
#javascript #websitedevelopment
Třeba se to někomu bude hodit, já si ušetřil několik hodin práce.
Potřeboval jsem porovnat dva Excelové sheety: pokud se čísla ve sloupci B shodují v obou, chci zkopírovat datumy ze sloupce H z prvního souboru do druhého. Nejsem líný, ale nechci manuálně kontrolovat stovky řádků.
#python #openpyxl
Potřeboval jsem porovnat dva Excelové sheety: pokud se čísla ve sloupci B shodují v obou, chci zkopírovat datumy ze sloupce H z prvního souboru do druhého. Nejsem líný, ale nechci manuálně kontrolovat stovky řádků.
#python #openpyxl
January 7, 2025 at 9:47 AM
python-docx / openpyxl で「配れる書類」にするまでに潰した4つ | shinsei99 #zenn
https://zenn.dev/shinsei99/articles/office-report-layout
https://zenn.dev/shinsei99/articles/office-report-layout
python-docx / openpyxl で「配れる書類」にするまでに潰した4つ
zenn.dev
September 21, 2026 at 5:13 PM
python-docx / openpyxl で「配れる書類」にするまでに潰した4つ | shinsei99 #zenn
https://zenn.dev/shinsei99/articles/office-report-layout
https://zenn.dev/shinsei99/articles/office-report-layout
❓🐍 Quiz: A Guide to Excel Spreadsheets in Python With openpyxl Quiz
buff.ly
July 23, 2026 at 12:02 PM
❓🐍 Quiz: A Guide to Excel Spreadsheets in Python With openpyxl Quiz
As a bonus I had GPT-5 figure out how to render the resulting chart entirely in the browser using Pyodide to run Python and matplotlib using WebAssembly - here's the result tools.simonwillison.net/ai-adoption
September 9, 2025 at 6:56 AM
As a bonus I had GPT-5 figure out how to render the resulting chart entirely in the browser using Pyodide to run Python and matplotlib using WebAssembly - here's the result tools.simonwillison.net/ai-adoption
import os
import xlrd
from openpyxl import Workbook
def convert_xls_to_xlsx(xls_path):
book_xls = xlrd.open_workbook(xls_path)
sheet_xls = book_xls.sheet_by_index(0)
book_xlsx = Workbook()
sheet_xlsx = book_xlsx.active
sheet_xlsx.title = sheet_xls.name
import xlrd
from openpyxl import Workbook
def convert_xls_to_xlsx(xls_path):
book_xls = xlrd.open_workbook(xls_path)
sheet_xls = book_xls.sheet_by_index(0)
book_xlsx = Workbook()
sheet_xlsx = book_xlsx.active
sheet_xlsx.title = sheet_xls.name
October 28, 2025 at 1:32 PM
import os
import xlrd
from openpyxl import Workbook
def convert_xls_to_xlsx(xls_path):
book_xls = xlrd.open_workbook(xls_path)
sheet_xls = book_xls.sheet_by_index(0)
book_xlsx = Workbook()
sheet_xlsx = book_xlsx.active
sheet_xlsx.title = sheet_xls.name
import xlrd
from openpyxl import Workbook
def convert_xls_to_xlsx(xls_path):
book_xls = xlrd.open_workbook(xls_path)
sheet_xls = book_xls.sheet_by_index(0)
book_xlsx = Workbook()
sheet_xlsx = book_xlsx.active
sheet_xlsx.title = sheet_xls.name
OpenPyXLをインストールした！
January 1, 2025 at 2:56 PM
OpenPyXLをインストールした！
openpyxl is a Python package that's been around for 10 years or so. It has the advantage of being battle tested, but there are much faster options out there today.
September 16, 2025 at 2:21 PM
openpyxl is a Python package that's been around for 10 years or so. It has the advantage of being battle tested, but there are much faster options out there today.
Learnt a bucnh at #PyconUS about using Python + XLSX:
* Use pandas read_excel() to turn XLSX > dataframe, and to_excel() to turn a dataframe -> XLSX:
github.com/crazy4pi314/...
* Use openpyxl to create a spreadsheet from scratch, complete with working formulas & charts
github.com/crazy4pi314/...
* Use pandas read_excel() to turn XLSX > dataframe, and to_excel() to turn a dataframe -> XLSX:
github.com/crazy4pi314/...
* Use openpyxl to create a spreadsheet from scratch, complete with working formulas & charts
github.com/crazy4pi314/...
May 14, 2025 at 9:05 PM
Learnt a bucnh at #PyconUS about using Python + XLSX:
* Use pandas read_excel() to turn XLSX > dataframe, and to_excel() to turn a dataframe -> XLSX:
github.com/crazy4pi314/...
* Use openpyxl to create a spreadsheet from scratch, complete with working formulas & charts
github.com/crazy4pi314/...
* Use pandas read_excel() to turn XLSX > dataframe, and to_excel() to turn a dataframe -> XLSX:
github.com/crazy4pi314/...
* Use openpyxl to create a spreadsheet from scratch, complete with working formulas & charts
github.com/crazy4pi314/...
Open Question on Bar Chart in OpenPyXL: github.com/yasenstar/le..., welcome to comments and inputs
BarChart is created but it's Column Chart in Excel · yasenstar learn_openpyxl · Discussion #2
I raise this question to openpyxl project site: https://foss.heptapod.net/openpyxl/openpyxl/-/issues/2307 Would like to get comments from anyone of you who also checks this type of chart. Regards, ...
github.com
January 1, 2026 at 3:08 AM
Open Question on Bar Chart in OpenPyXL: github.com/yasenstar/le..., welcome to comments and inputs
If you do go the python route, I’ve used openpyxl to ingest a ton of excel data and then spit out a summary (also in xlsx).
openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files — openpyxl 3.1.3 documentation
openpyxl.readthedocs.io
December 20, 2025 at 12:45 AM
If you do go the python route, I’ve used openpyxl to ingest a ton of excel data and then spit out a summary (also in xlsx).
Asinine that they used openpyxl instead of calamine/fastexcel.
September 16, 2025 at 7:11 AM
Asinine that they used openpyxl instead of calamine/fastexcel.
Openpyxl and xlwings (windows only) work with whatever excel you have.
May 14, 2025 at 12:19 PM
Openpyxl and xlwings (windows only) work with whatever excel you have.