Formulas
Formulas

Formulas (7)

The sample demonstrates how to set Excel subtotal formula via Spire.XLS.

The sample demonstrates how to read data with fomulas

The sample demonstrates how to calculate formulas

The sample demonstrates how to export data to datatable with calculating formulas

The sample demonstrates how to define named cell references or ranges in excel workbook.

Download MiscDataTable.xls

 
 
 The sample demonstrates how to write formulas into spreadsheet..

WriteFormulas.gif

 
 
The sample demonstrates how to read formulas from spreadsheet.

ReadFormulas.gif