Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
Fri Jan 14, 2011 1:56 am
Few days ago, I added many formulas for my Excel Worksheet. Today, I check these formulas and find that some formulas are unnecessary. Can I delete the useless formulas with Spire.XLS?
Yes, you can. I will take an example for you. If you want to clear any content of any cell, you can use the following code: sheet.Range[7,1].Clear(ExcelClearOptions.ClearContent);