View Source

The RemoveFormulas method removes Excel formulas from the entire workbook, while leaving their values in cells. This method does NOT remove Conditional Formatting or Data Validation.

 public void RemoveFormulas()

 Public Sub RemoveFormulas()

//Create an ExcelApplication object
ExcelApplication xla = new ExcelApplication();

//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx); 
 
//Call RemoveFormulas
wb.RemoveFormulas();

'Create an ExcelApplication object
Dim xla As New ExcelApplication
 
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
 
'Call Removeformulas
wb.RemoveFormulas()