Answers for "openpyxl multiple worksheets in python"

1

how to create multiple sheets in excel using python in openpyxml

1from openpyxl.workbook import Workbook
 2
 3wb = Workbook()
 4
 5ws1 = wb.create_sheet("Sheet_A")
 6ws1.title = "Title_A"
 7
 8ws2 = wb.create_sheet("Sheet_B", 0)
 9ws2.title = "Title_B"
10
11wb.save(filename = 'sample_book.xlsx')
Posted by: Guest on October-20-2020

Code answers related to "openpyxl multiple worksheets in python"

Python Answers by Framework

Browse Popular Code Answers by Language