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?

eternalsummer
 
Posts: 11
Joined: Mon Dec 13, 2010 7:31 am

Mon Jan 17, 2011 11:14 am

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);
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS

cron