Message-ID: <568682124.8677.1711654976152.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8676_851130913.1711654976152" ------=_Part_8676_851130913.1711654976152 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.RemoveFormulas

Worksheet.RemoveFormulas

Introduced in buil= d 9.1

Description

The RemoveFormulas method removes Excel formulas from the worksheet,= while leaving their values in cells. This method does NOT remove Condition= al Formatting or Data Validation.=20
C#
=20
 public void RemoveFormulas()
=20
=20
vb.net
=20
 Public Sub RemoveFormulas()
=20
=20

Examples

=20
C#
=20
//Create an ExcelApplication object
ExcelApplication xla =3D new ExcelApplication();

//Open a workbook containing formulas
Workbook wb =3D xla.Open("FormulasWorkbook.xlsx); 
 
//Call RemoveFormulas
wb["Worksheet1"].RemoveFormulas();
=20
VB
=20
'Create an ExcelApplication object
Dim xla As New ExcelApplication
 
'Open a workbook containing formulas
Dim wb As Workbook =3D xla.Open("formulasWorkbook.xlsx")
 
'Call Removeformulas
wb["Worksheet1"].RemoveFormulas()
=20
------=_Part_8676_851130913.1711654976152--