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.

Challenge: Split a workbook

Challenge: Split 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

Challenge: Split a workbook

“

(upbeat music) - [Joe] All right, it's time for another programming challenge. For this challenge, you're going to take the Financial Sample workbook that we've been using in the chapter and split the worksheet that contains all the data into multiple worksheets, each of which represent the data for a given country, which is contained in column B. So I'm going to run my finished code so you can see what your result should look like when you're done. So I'm going to go ahead and run my finished solution. And when I do that, you can see that there's a new Financial Sample workbook that has been created. So let's go ahead and open that up in Excel. Okay, so when I open this, we can see that here is the original worksheet with all of its original data, and here is the blank Sheet2, which is untouched, so that's still there. And there's also new worksheets for each of the countries in the dataset. So here's Canada, Germany, France, Mexico, and the United States. And you can see that that…

Contents