We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Clearing data from existing cell

Hi,

How do I clear the data from an existing cell? (I.e set it back to null).

Thanks

Bill

Hi Bill,

Well, I think you may use Cell.PutValue(null/Nothing) for your need. Check the following code below:

e.g..,

Workbook book = new Workbook();
book.Open("f:\\test\\Book1.xls");
book.Worksheets[0].Cells["A1"].PutValue(null);
book.Worksheets[0].Cells["A2"].PutValue(null);
book.Save("f:\\test\\out_Book1.xls");

Thank you.

Fantastic. Thank you Amjad