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 »
My 10th Python book is called Automating Excel with Python: Processing Spreadsheets with OpenPyXL. It only has 11 more days to go on Kickstarter where you can get an exclusive t-shirt! I also have the eBook available for pre-order on Gumroad. No matter whether you purchase a copy on Kickstarter or Gumroad, you will be
Pre-Order Automating Excel with Python Read More »
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 »
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 »