How to save excel with values only excluding formulas


#1

Thanks in advance


#2

In Excel application scope, read range and write data to DataTable, after that create a new Excel file with DataTable. Or you can invoke vb.net to delete the formula of cells.