可以在xlsxwriter中更改工作表顺序吗? [英] Possible to alter worksheet order in xlsxwriter?

问题描述

我有一个脚本，可以按顺序创建以下几对工作表:

I have a script which creates a number of the following pairs of worksheets in order:

WorkSheet (holds data) -> ChartSheet using WorkSheet

脚本完成后，剩下的工作表按如下顺序排列:

After the script is finished, I am left with worksheets ordered as such:

Data1, Chart1, Data2, Chart2, Data3, Chart3, ...

是否可以在脚本末尾(即在workbook.close()之前)重新排序工作表，以便在最终的.xlsx文件中获得以下工作表顺序?

Is it possible to re-order the worksheets at the end of the script (i.e. before workbook.close()) to obtain the following worksheet order in the final .xlsx file?

Chart1, Chart2, Chart3,...,ChartN, Data1, Data2, Data3,...

推荐答案

只需对workbook.worksheets_objs列表进行排序:

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()

这篇关于可以在xlsxwriter中更改工作表顺序吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！