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