Python Workbook._active_sheet_index 예제들

예제 #1

파일: result_analysis.py 프로젝트: nitthilan/optimising_structured_combinatorial_spaces

def dump_xlsx():
    wb = Workbook()

    wb._active_sheet_index = 0  # xetting the sheet
    ws = wb.active
    ws.title = "New Title"

    ws = wb.create_sheet("EDP sheet", 0)

    ws['A4'] = 4
    ws.cell(row=4, column=2, value=10)

    wb.save('example.xlsx')

예제 #2

from openpyxl import Workbook
wb = Workbook()
ws2 = wb.create_sheet()
ws3 = wb.create_sheet()
print(wb.sheetnames)
print(wb._active_sheet_index)
wb._active_sheet_index = 1
print(wb._active_sheet_index)