From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Loading and exploring a workbook

Loading and exploring a workbook

From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Start my 1-month free trial Buy for my team

Loading and exploring a workbook

“

- [Instructor] Let's start by using OpenPyXL to load and explore some data in a workbook. I'm going to be using this sample Excel file right here named Financial Sample.xlsx. Now, if you don't have Excel, you can install an extension for VS Code called Excel Viewer, which I already have installed. So I'm going to go over to my extensions panel and scroll down, and you can see it's called Excel Viewer right here. It's by Grape City. You can see it has millions of downloads and some very high ratings on the store. You can find this extension in the marketplace by doing a search for it, like we did earlier for the Python extension, and it's free. So go ahead and install it, and you can see that when I click on an Excel file here in code, I actually get this nice visualization of the contents of the workbook without having to use the full Excel program. And like I said, it's free. It works really well. So I suggest installing it if you can't use Excel. Now, I do have Excel on my computer,…

Contents