Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Read and Write Excel Files in Python

Introduction
Working with Excel Files
Summary

Instruction

We can also create a new spreadsheet with the create_sheet() method:

wb.create_sheet("January")

This function takes two arguments: the title of the new worksheet and an index. The index of the new worksheet specifies its order in the workbook. You can omit the index argument, as we did in the example; in that case, the new sheet will be added after all the existing sheets in the workbook.

Exercise

Create four additional worksheets in our existing wb workbook:

  1. Housing
  2. Entertainment
  3. Food
  4. Other

Save the workbook in the file budget.xlsx.