OpenPyXL

Styling Excel Cells with OpenPyXL and Python

OpenPyXL gives you the ability to style your cells in many different ways. Styling cells will give your spreadsheets pizazz! Your spreadsheets can have some pop and zing to them that will help differentiate them from others. However, don’t go overboard! If every cell had a different font and color, your spreadsheet would look like …

Styling Excel Cells with OpenPyXL and Python Read More »

Creating Spreadsheets with OpenPyXL and Python

Reading Excel spreadsheets is all well and good. However, you also need to be able to create or edit a spreadsheet. The focus of this chapter will be on learning how to do that! OpenPyXL lets you create Microsoft Excel spreadsheets with a minimum of fuss. Creating Excel spreadsheets using Python allows you to generate …

Creating Spreadsheets with OpenPyXL and Python Read More »

Reading Spreadsheets with OpenPyXL and Python

There are a couple of fundamental actions that you will do with Microsoft Excel documents. One of the most basic is the act of reading data from an Excel file. You will be learning how to get data from your Excel spreadsheets. Editor’s note: This article is based on a chapter from the book: Automating …

Reading Spreadsheets with OpenPyXL and Python Read More »