We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The Syncfusion® .NET Excel library (XlsIO) provides comprehensive support for handling and manipulating Excel formulas. Users can seamlessly create, manage, and calculate formulas within worksheets, extending the functionality and capabilities of their Excel workbooks. This library supports 400+ built-in Excel functions for creating Excel documents.

Execute Formula Code Example

This example code shows how to add a formula to an Excel worksheet using the Syncfusion® .NET Excel Library with just a few lines of C# code.

// Initialize Excel engine and application
using ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Xlsx;
// Create a workbook and worksheet
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet sheet = workbook.Worksheets[0];
// Setting values to the cells
sheet.Range["A1"].Number = 10;
sheet.Range["B1"].Number = 10;
// Setting formula in the cell
sheet.Range["C1"].Formula = "=SUM(A1,B1)";
// Save the Excel document
using FileStream stream = new FileStream("Formula.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(stream);

Key features of Formula

Discover how the formula capabilities in the Excel Library simplify complex calculations and efficiently handle formulas within Excel worksheets.

Array of formula

Apply a single formula to a range of cells to perform calculations on multiple values at once. This enhances efficiency and reduces manual input, while ensuring accurate, consistent results across large datasets.

Incremental formula

Apply a formula across a range of cells, where each cell calculates based on its relative position or sequence, incrementing by 1.

External formula

Formulas that reference data from other worksheets or workbooks, enabling calculations that integrate information across multiple sources.

Defined name ranges formula

Formulas that use predefined name ranges to refer to specific cells or ranges, enhancing readability and simplifying formula management by allowing easy updates and consistent references across the workbook.

Calculated column

A column within an Excel table where each cell contains a formula that automatically updates based on the table’s data. This feature ensures dynamic and consistent calculations as rows are added or modified, simplifying data management and analysis.

Calculate options

Determine how and when Excel recalculates formulas, including automatic or manual recalculation modes, options to recalculate before saving, and settings for iterative calculations to meet specific numeric conditions.

Explore Formula References

Discover valuable resources from our blog and knowledge base articles to enhance your efficiency in using Excel formulas.

Generate a Loan EMI Schedule as an Excel Document Using C#

Blog

Generate a Loan EMI Schedule as an Excel Document Using C#

How to add an Excel chart title with a formula in C# and VB.NET

Knowledge base

How to add an Excel chart title with a formula in C#, VB.NET

How to add an Excel chart data label with a formula in C# and VB.NET

Knowledge base

How to add an Excel chart data label with a formula in C#, VB.NET

Paste only the formula value of Excel cell in C# and VB.NET

Knowledge base

Paste only the formula value of Excel cell in C#, VB.NET

How to add nested IF function in Excel document using C#

Knowledge base

How to add nested IF function in Excel document using C#

Syncfusion .NET Excel Library Resources

Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.

Frequently Asked Questions

The Syncfusion® Excel library supports various formulas, including mathematical functions, logical operators, text manipulation functions, date and time functions, and statistical functions. Users can use over 400 built-in Excel functions to create dynamic Excel documents for their specific needs.

Yes. Users can enable or disable the calculation mode for XlsIO.

No. The named range name should be unique in a worksheet when the named range scope is worksheet level. You can create a named range with the same name but with a workbook level scope.

Yes. The Syncfusion® Excel library provides comprehensive support for manipulating and calculating Excel formulas programmatically using C# code. Users can seamlessly create, modify, and evaluate Excel formulas within worksheets, extending the functionality and capabilities of their Excel workbooks while maintaining data integrity and accuracy.

Yes. The Syncfusion® Excel library uses the argument and list separators for formulas based on the application’s system culture. However, it allows you to modify the separators easily.

Yes. The Syncfusion® Excel library allows the addition of formulas with add-in functions and creation of Excel documents.

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion® reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Want to create, View, and edit Excel files in C# or VB.NET?

Start a free 30-day evaluation today!
DOWNLOAD FREE TRIAL

No credit card required.

Mobile Free Evaluation Section

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion® is proud to hold the following industry awards.

Scroll up icon