Python xlsxwriter - add a worksheet to an existing workbook

Question

I am doing my first steps with xlswriter.

I have an existing workbook test.xlsx, and I want to add to it a new worksheet - sheet 2.

what I tried is the following:

import xlsxwriter as xl
xbook=xl.Workbook('test.xlsx')
xbook.add_worksheet('sheet2')

The problem with this is that it overrides all the other sheets in the workbook. How can I add a worksheet without overriding all the other worksheets in the workbook?

Solution

I don't think this is still possible with xlsxwriter. Please take a look at this answer for help