• Material 3
  • Material 3 Dark
  • Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Formulas in ASP.NET Core Excel (XlsIO) Library

This sample demonstrates how to use formulas in spreadsheets using XlsIO.
DEMO
SOURCE

Click the "Read Formula" button to view the formula and its CalculatedValue. Click the "Write Formula" button to view the Excel spreadsheet generated by Essential XlsIO. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.


  

   

Formulas are entries in Excel that have an equation that calculates the value to be displayed. A typical formula might contain cells, constants, and even functions. Essential XlsIO has support for reading and writing formulas.


Features:

  • Writing array formulas
  • Writing Excel built-in formulas
  • Reading formula strings using XlsIO
  • Reading evaluated formulas using XlsIO