In Automating Excel with Python: Processing Spreadsheets with OpenPyXL, you will learn how to use Python to create, edit, or read Microsoft Excel documents using OpenPyXL. This course is based on the book, Automating Excel with Python by Michael Driscoll. Python is a versatile programming language. You can use Python to read, write and edit […]
NEW COURSE: Automating Excel with Python on Udemy Read More »
Microsoft announced that Python is now a part of Excel! Guido van Rossum mentioned on Twitter that he helped the Excel team add Python to the popular spreadsheet application. You can get Python in Excel if you have the ability to access Public Preview versions of Office. This new feature allows you to write Python
Python in Excel Announcement! Read More »
Introduction to Batch APIs In modern Python applications, it’s common to access remote API using REST or other web-based technologies. Batch APIs are capable of processing multiple requests with a single call. You can use batch APIs to reduce the number of network calls to the remote service. This is ideal when you have to
Using Asyncio and Batch APIs for Remote Services Read More »
In this tutorial, I will show you an overview of using OpenPyXL and Python to read and write Excel documents. You will also learn how to: Style cells Change fonts Create named styles Use pandas with Excel Combine pandas and OpenPyXL Basics of using XslxWriter The code in this tutorial is based on code from
Automating Excel with Python Video Overview Read More »
My 10th Python book, Automating Excel with Python is now available on Amazon in Paperback or Kindle versions. In this book, you will learn how to use Python to do the following: Create Excel spreadsheets Read Excel spreadsheets Create different cell types Add and remove sheets Convert Excel spreadsheets into other file types Cell styling
Automating Excel with Python Paperback Now Available! 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 »
Last month we looked at how to create Microsoft Excel (i.e. *.xls) files using the xlwt package. Today we will be looking at how we can read an *.xls/*.xlsx file using a package called xlrd. The xlrd package can be run on Linux and Mac as well as Windows. This is great when you need
Reading Excel Spreadsheets with Python and xlrd Read More »
Most typical users have used Microsoft Office. While Office may be the bane of tech support, we still have to deal with it. Python can be used to script (AKA automate) Office and make it easier for us or our users to use. It may not be as easy as recording a macro, but it’s
Python and Microsoft Office – Using PyWin32 Read More »