Delete row/column from Excel with xlsxwriter

Question

Is it possible?

I know ws.set_row('B:B', options={'hidden': True})

But, is there something like ws.set_row('B:B', options={'delete_row': True})?

Pyuria

Answer 1

It doesn't seem possible to do what you ask. Probably the best approach remains the one proposed in this old post.

Mistakable

Answer 2

To quote the Worksheet docs:

"""
The options parameter is a dictionary with the following possible keys:

'hidden'
'level'
'collapsed'
""""

Other values like delete_row are not acceptable.

Val

Answer 3

You cannot delete a column with XlsxWriter. The best option is to structure your application so it doesn't write data to the column in the first place.

Claudioclaudius