Russ Ebytongere.hashnode.dev·Jan 31, 2024Python - OpenPyXL - Styling a SpreadsheetThe 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...Discuss·1 like·65 readsOpenPyXL - Automating Spreadsheetsopenpyxl
Nuwan Wickramarachchiblog.nuwanwick.dev·Jan 13, 2024How I made data onboarding 4X faster 🚀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 ...Discuss·71 readsdata onboarding
Russ Ebytongere.hashnode.dev·Oct 22, 2022OpenPyXL - Working with CSV FilesWelcome 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...Discuss·1 like·3.4K readsOpenPyXL - Automating SpreadsheetsPython
Russ Ebytongere.hashnode.dev·Oct 22, 2022OpenPyXL - Using Python to Automate SpreadsheetsPython is a general-purpose language that is capable of working on many different project types. People create web sites, games, data science, utilities and so much more. A common application for Python is to process spreadsheets and CSV files. Many ...Discuss·1 like·140 readsOpenPyXL - Automating Spreadsheetsopenpyxl
Sunkanmi Fafoworasunkanmi.hashnode.dev·Jul 22, 2021How to Edit Excel Sheets with Python using openpyxlLet's say your boss gave you the task to compare names of employees in different regions on separate excel sheets and tells you to state on the first excel sheet on a separate column whether or not the employee is working at another branch by the end...Aman Paul and 1 other are discussing this2 people are discussing thisDiscuss·47 likes·916 readsPython