Example of Table Formula in ASP.NET MVC Excel (XlsIO) Library
This sample demonstrates how to use formulas in spreadsheets using Excel (XlsIO) Library.
In Excel 2013 and later versions calculated column formula can be used in tables.
XlsIO supports reading and writing calculated columns and formulas.
Features:
- Adding tables to a spreadsheet
- Advanced options of Excel tables such as total rows and styles
- Writing calculated column formula