This sample demonstrates how to use formulas in spreadsheets using XlsIO.
Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please
note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.
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