This sample demonstrates how to use formulas in spreadsheets using XlsIO.
In Excel 2013 and later versions calculated column formula can be used in tables.
XlsIO supports reading and writing calculated columns and formulas.
- Adding tables to a spreadsheet
- Advanced options of Excel tables such as total rows and styles
- Writing calculated column formula