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})?

score 3 · Answer 1 · edited Oct 24 '19 at 13:03

3

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.

edited Oct 24 '19 at 13:03

alecxe

462,703
120
1,088
1,195

answered Oct 24 '19 at 12:41

ArunJose

1,999
1
10
33

score 3 · Answer 2 · answered Oct 24 '19 at 13:14

3

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

answered Oct 24 '19 at 13:14

Massifox

4,369
11
31

score 0 · Answer 3 · answered Oct 24 '19 at 15:01

0

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.

answered Oct 24 '19 at 15:01

jmcnamara

38,196
6
90
108

Delete row/column from Excel with xlsxwriter

3 Answers3