Preferences

Theme Selection

Theme Modes

Mode Selection

Touch

Mouse

Localization

*Translated by Google Translator.

Currency

HOME

All Controls

XlsIO
Default
Product Showcase
Budget Planner
Attendance Tracker
Call Center Dashboard
Expenses Report
Yearly Sales
Getting Started
Create
Find And Extract
Replace Options
Formatting
Format Cells
Styles and Formatting
Conditional Formatting
Charts
Chart Worksheet
Embedded Chart
Sparklines
Box and Whisker
Funnel Chart
Treemap
Sunburst
Formulas
Formulas
Compute All Formulas
Table Formula
External Formula
Data Management
Range Manipulation
Data Validation
Chart Performance
Interactive Features
Form Controls
Data Sorting
Filters
Slicer
What-If Analysis
Auto Fill & Fill Seriesnew
Data Binding
Template Marker
Collection Objects
Import Nested Collection
Import JSON
Import HTML Table
Import Export DataTable
Sheet Management
Row-Column Manipulation
Worksheet Management
Conversions
Excel To PDF
Excel To PDF/UA
Worksheet To Image
Excel To ODS
Excel To JSON
Settings
Documentation Settings
Worksheet Protection
Workbook Protection
Encrypt and Decrypt
Business Intelligence
Table
Pivot Table
Pivot Chart
Pivot Table Layout
Shapes
AutoShapes
Group Shapes
Comments
Macros
Create Macro
Edit Macro

Example of External Formula in ASP.NET MVC Excel (XlsIO) Library

Excel (XlsIO)

Formulas

External Formula

This sample demonstrates how to use External formula in spreadsheets using Excel (XlsIO) Library.

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.

Formula String

Computed Value

External Formula that refers to a value in another workbook. An external formula is a reference to a cell or range of cells in another workbook.

Features:

Reading formula strings using Excel (XlsIO) Library
Reading evaluated formulas using Excel (XlsIO) Library