1

If the third column contains the value N, then I need to be able to delete the entire row.

I'm trying to automate this using python and xlwt, but am not quite sure where to start.

It would be grateful if somebody can help through a small code snippet.

akansha shah
  • 11
  • 1
  • 3
  • 2
    I know you want xlwt.. I achieve this using pandas: `DataFrame.dropna(self, axis=1, how='any', thresh=None, subset=None)` See : http://pandas.pydata.org/pandas-docs/stable/missing_data.html – Moritz Aug 06 '15 at 10:34
  • http://stackoverflow.com/questions/16616563/in-python-removing-rows-from-a-excel-file-using-xlrd-xlwt-and-xlutils – Praveen Aug 06 '15 at 10:37

1 Answers1

0

xlwt does not provide directly this kind of functionality.

One solution is to read from one .xls and write to a new one.

You can find here all funcionalities from xlwt api

Pasqual Guerrero
  • 406
  • 2
  • 8