openpyxl only returns one column code example
Example: add sheet to existing workbook openpyxl
from openpyxl.workbook import Workbook
wb = Workbook()
ws1 = wb.create_sheet("Sheet1")
ws1.title = "Title1"
ws2 = wb.create_sheet("Sheet2")
ws2.title = "Title2"
wb.save(filename="filename.xlsx")