.NET Excel Library - Use Excel formulas in C#
- Create, read, and edit formulas.
- Use 400+ Excel functions for calculation.
- Use named ranges, table, and array formulas.
Try C# Excel Examples in Playground app.
FREE TRIALNo credit card required.
Explore ExamplesNo credit card required.
Trusted by the world’s leading companies
.NET excel library formula
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.
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#
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Frequently Asked Questions
What types of formulas are supported in the Syncfusion® Excel library?
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.
Is enabling or disabling the formula calculation mode in the Syncfusion® Excel library possible?
Yes. Users can enable or disable the calculation mode for XlsIO.
Can I create multiple named ranges with the same name in a single worksheet?
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.
Can I manipulate and calculate Excel formulas using the Syncfusion® Excel Library?
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.
Does the Syncfusion® .NET Excel library manipulate formulas based on the system culture?
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.
Can I use add-in functions in the Syncfusion® Excel Library?
Yes. The Syncfusion® Excel library allows the addition of formulas with add-in functions and creation of Excel documents.
Our Customers Love Us
Here are some of their experiences.
See Real Success Stories
Developers around the world trust Syncfusion’s Essential Studio to simplify complex projects and speed up delivery. With a vast library of UI controls, powerful SDKs, and reliable support, Essential Studio helps teams build enterprise-ready applications with confidence.
Read Our Customer StoriesIndustry
Software development
75% Cost reduction
50% Faster development
“If somebody is looking for a great tool to work with? Yes. I would definitely recommend Syncfusion for anyone who is trying to develop something meaningful.”
- Somnath Maji (Founder of Igniatek Consultancy)
Read StoryIndustry
Utilities (oil and gas)
Advanced, flexible features
Empowered users through robust and versatile functionality.
“Syncfusion’s tools have taken care of many things so I can focus on developing the application, instead of developing tools for the application.”
- James Athyal (Software developer, McDaniel & Associates Consultants Ltd)
Read StoryIndustry
Software and technology
Efficient file management
Streamlined workflows with document libraries without building them from scratch.
“We really love when the magic happens.”
- Irvin Dominin (BUILDER WEB Development Manager at Sistemi)
Read StoryIndustry
Software and technology
“We are Syncfusion fans because of the way Syncfusion treats the support.”
- Dr. Howard Rybko (CEO of Synchrony Digital)
Read StoryIndustry
IT services and IT consulting
Improved performance
Large datasets handled with easy customization and quick debugging.
“I will surely recommend Syncfusion to others as a third-party control because I think it’s very easily customizable.”
- Jayesh (Technical Team Lead, Capita)
Read StoryIndustry
Professional services
“We definitely wanted Syncfusion to help us with our document processing functionality, and we were happy with and satisfied with Syncfusion.”
- Arvind Naik (Engineering Lead, Vialto Partners)
Read StoryRated by users across the globe
Want to create, View, and edit Excel files in C# or VB.NET?
No credit card required.
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.
