top of page

Creating an Excel Workbook and Naming Worksheets


Using the Openpyxl module you can use Python to create an Excel workbook and name its worksheets. Follow these steps:

First import the openpyxl module

>>> import openpyxl

Then import the Workbook class from openpyxl >>> from openpyxl import Workbook

Identify the workbook >>> wb = Workbook()

Name the worksheet >>> sheet = wb.active >>> sheet.title = "identification"

Then save the workbook as a new Excel file >>> wb.save('edrm4.xlsx')

A new workbook is created with a worksheet named 'identification'.

Additional sheets can be created and named.

>>> sheet2 = wb.create_sheet()

Specify which number worksheet you want to name. 1 is the second worksheet. >>> sheet2 = wb.worksheets[1] >>> sheet2.title = "preservation"

It's necessary to save the workbook before the sheet will be created in the file. >>> wb.save('edrm4.xlsx')


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page