Clearing data from existing cell

Aspose.Cells Product Family
1

Hi,

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

Thanks

Bill

2

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.

3

Fantastic. Thank you Amjad