May 30, 2025 · 2 min read · Working with Excel data across multiple sheets and comparing rows against reference blocks is tedious — especially when done manually. I built a lightweight web tool using Streamlit that automates this for analysts inside our company. 🔍 What the To...
Join discussionMay 21, 2025 · 2 min read · I built a Python automation script to read diamond inventory from an Excel file, sends queries to the Nivoda API for market prices, and writes the price and price per carat back into the Excel file. 🔍 What It Does Reads Excel inventory file Sends...
Join discussionJan 5, 2025 · 2 min read · 소개 이번에 새 프로젝트 Schedulize를 소개하게 되어서 굉장히 기쁩니다. 아직 제작 중이지만 현재 80% 완료된 상태이고 최적화를 위해 꾸준한 코드 리팩토링(Refactoring)을 거칠 예정입니다. Schedulize는 영어 Schedule과 Optimize를 합쳐 최적화된 스케줄을 제공한다는 것에 초점을 두었습니다. 어떤 프로젝트를 시작하는 데에는 모두가 이유가 있다고 생각합니다. 개인적으로 저는 “혁신”을 위하여 개발합니다. 이번 ...
Join discussion
Jan 4, 2025 · 1 min read · Error I was working on my mini project called Schedulize, and an error occured while loading a workbook using openpyxl. def create_excel_file(self): wb = load_workbook(self.file_path) # IndexError: list index out of range ws = wb.active ...
Join discussion
Dec 15, 2024 · 5 min read · Introduction Excel remains one of the most powerful tools for organizing and analyzing data, but repetitive tasks like formatting, data entry, and report generation can consume hours of your time. This is where automation steps in. OpenPyXL is a Pyth...
Join discussion
Dec 6, 2024 · 5 min read · 1. Read .xlsb Files (pyxlsb) from pyxlsb import open_workbook with open_workbook('example.xlsb') as wb: with wb.get_sheet(1) as sheet: for row in sheet.rows(): print([item.v for item in row]) Sample Output: ['Header1', 'Head...
Join discussionSep 12, 2024 · 1 min read · Sure, you can use the openpyxl library in Python to create an Excel workbook. Here's a basic example: from openpyxl import Workbook # Create a workbook and select the active worksheet wb = Workbook() ws = wb.active # Add some data ws['A1'] = 'Hello...
Join discussion
Jan 31, 2024 · 13 min read · The best way to learn anything is to actually try it. Let's see how OpenPyXL works and style a spreadsheet. The Dataset I've chosen is a CSV of Countries of the World (kaggle.com). For this post I'm assuming you have a working knowledge of Python and...
Join discussion
Jan 13, 2024 · 2 min read · The challenge While I was working at Assetowl, a property management solutions company in Australia, I faced and solved a big problem that greatly improved how we brought data into our system. When acquiring new customers we had to import their past ...
Join discussion
Oct 22, 2022 · 4 min read · Welcome to the second part in this series. This isn't covering features of OpenPyXL directly. But since a lot of the data brought into Excel is from CSV files. I thought we should get this out of the way. OpenPyXL doesn't load CSV files directly. Wha...
Join discussion
