Delete Formulas

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Delete Formulas

Postby eternalsummer » 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

Re: Delete Formulas

Postby iceblue support » 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: 244
Joined: Tue Dec 21, 2010 2:56 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests