Sort Leaves in xlsx

0

I have xlsx with three sheets and a code to sort them but I want to sort them in my own way and not by name:

import xlsxwriter

workbook = xlsxwriter.Workbook('test.xlsx')

sheet_names = ['Data1', 'Chart1', 'Data2', 'Chart2', 'Data3', 'Chart3']
for sheet_name in sheet_names:
    workbook.add_worksheet(sheet_name)

# sort sheets based on name
workbook.worksheets_objs.sort(key=lambda x: x.name)
workbook.close()

Distribution I need:

sheet_names = ['Data1', 'Chart1', 'Chart3', 'Chart2', 'Data3', 'Data2']
    
asked by Martin Bouhier 12.01.2018 в 16:54
source

0 answers