ComponentOne Data Services CalcEngine
Parse and evaluate Excel-like expressions across .NET platforms.
- Supports Excel and VBA-like syntax for complex calculations.
- Enables data binding with collections and tables for dynamic formulas.
- Allows cross-sheet referencing within multiple data collections.
Prices from:
| Available in | |
|---|---|
| ComponentOne Studio Data Services Edition | Loading |
| ComponentOne Studio WinForms Data Services Edition | Loading |
| ComponentOne Studio Enterprise | Loading |
Expression Parsing and Evaluation
CalcEngine interprets and executes algebraic and Excel-style expressions, enabling mathematical and logical operations similar to spreadsheet software within .NET applications.
Support for VBA and Excel Syntax
The engine includes VBAEngine and ExcelEngine, supporting VBA-like syntax for standard data sources and Excel-like syntax for IDataSheet-based data sources, covering a wide range of calculation scenarios.
Extensive Built-in Functions
It offers numerous built-in functions including text, date/time, math, logical, conversion, and aggregate functions, facilitating complex computations and data analysis.
Custom Function Integration
Developers can extend functionality by adding their own custom functions to the engine using the AddFunction method, enhancing calculation capabilities.
Data Binding Capabilities
CalcEngine binds to various data sources such as lists, arrays, or data tables, allowing expressions to operate on collections or individual objects for dynamic data-driven calculations.
Cross-Sheet Referencing
The engine supports referencing cells and ranges across multiple data tables via cross-sheet references using sheet names and cell ranges, enabling consolidated calculations from distributed data.
Error Handling and Diagnostics
It provides error tracking with detailed messages accessible through the GetErrors method, helping developers identify and resolve issues in expressions effectively.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Component Type
- .NET
.NET Version
- .NET 8 LTS
- .NET 6 LTS
- .NET 4.8 or earlier
.NET Platform
- .NET Assembly
- .NET Class
About MESCIUS
MESCIUS, formerly known as GrapeCity, is a leading developer-focused brand established in Japan, with a history spanning over 30 years. It is recognized for its extensive suite of software components, including reporting frameworks, spreadsheet libraries, and Japanese market-oriented input controls. Popular products such as ActiveReports, SPREAD, InputMan, and ComponentOne support both .NET and JavaScript ecosystems and are widely used in business-critical applications. MESCIUS offers distinctive advantages such as proven reliability, comprehensive Japanese localization, and strong technical support, making it a trusted choice for IT professionals and software developers building complex and localized systems.
As official and authorized distributors since 1996, ComponentSource supplies you with legitimate licenses directly from MESCIUS.