.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.
No credit card required.
VIEW DEMONo credit card required.
Trusted by the world’s leading companies
Overview
The Syncfusion® .NET Excel library comprehensively supports 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.
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Product Updates
Technical Support
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 Syncfusion .NET Excel library .
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
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.
Explore Case StudiesIndustry
Software development
75%Cost reduction
50%Faster development
Industry
Utilities (oil and gas)
450+hours saved
Streamlined processes and hours of development effort saved.
Advanced, flexible features
Empowered users through robust and versatile functionality.
Industry
Software and technology
1000+of hours saved
Accelerated development with enterprise-ready UI components.
Efficient file management
Streamlined workflows with document libraries without building them from scratch.
Industry
Software and technology
2 Yearsof delay avoided
Two years of delays prevented with proactive planning.
On-time delivery
Projects delivered on schedule using trusted controls.
Industry
IT services and IT consulting
Improved performance
Large datasets handled with easy customization and quick debugging.
Highly customizable
Plug-and-play controls with quick template integration.
Industry
Professional services
Instant access
Quick availability of features and resources.
Reduced dependencies
Fewer dependencies for faster development.
Rated 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.
