ComponentOne WinForms Excel
Create and manipulate Excel workbooks within .NET applications.
- Represents Excel workbooks with multiple worksheets and features.
- Supports reading, writing, and formatting XLS and XLSX files.
- Enables adding images, comments, formulas, and custom styles.
Prices from:
| Available in | |
|---|---|
| ComponentOne Studio WinForms | Loading |
| ComponentOne Studio WinForms Data Services Edition | Loading |
| ComponentOne Studio Enterprise | Loading |
Workbook Representation
The core component is the C1XLBook class representing an Excel workbook. It manages multiple worksheets and allows loading existing Excel files or creating new workbooks from scratch.
Worksheet Management
The library provides XLSheet objects that represent individual sheets. Developers can add, rename, and manipulate sheets within a workbook programmatically.
Calculation and Compatibility Modes
Control formula calculation modes and specify compatibility levels to handle sheet sizes and style limits conforming to different Excel versions.
Advanced Workbook Features
Functionality includes grouping rows and columns with subtotals, handling named ranges, and managing print settings to replicate Excel behaviors.
No Excel Dependency
Operates independently of Microsoft Excel installations, enabling server or desktop use without requiring Office products on the host machine.
File Loading and Saving
Supports loading Excel files (.XLS, .XLSX, and .CSV) and saving workbooks with full fidelity. Load and save operations can be performed synchronously or asynchronously.
Rich Content Support
Add and edit cell formulas, images (including metaphoric files), cell comments (notes), and hyperlinks. Images can be positioned and scaled within cells or headers/footers.
Cell Access and Formatting
Data in sheets can be accessed via XLCell objects, supporting getting and setting values, applying styles such as fonts, colors, and number formats to enhance presentation.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Component Type
- .NET
.NET Version
- .NET 10 LTS
- .NET 9 STS
- .NET 8 LTS
- .NET 6 LTS
- .NET 4.8 or earlier
.NET Platform
- .NET Assembly
- .NET Class
- .NET WinForms
IDE Support
- Visual Studio
How to Buy
Available as part of ComponentOne WinForms Edition, ComponentOne WinForms Data Services Edition, and ComponentOne Studio Enterprise.
- Included120+ WinForms Controls
- Not included100+ WPF Controls
- Not included30+ WinUI & .NET MAUI Controls
- Not included40+ ASP.NET MVC & Core Controls
- Not included40+ ASP.NET WebForms Controls
- Not included19+ Blazor Components
- Not includedData Services/Web API
- Not included80+ JavaScript Controls
- Enterprise Controls
- Not includedFinancialChart
- Not includedFlexSheet
- Not includedFlexPivot/OLAP
- Not includedFlexReport Designer
- Not includedReportViewer
- Additional Features
- Not includedIntelliSpell
- Not included2200+ Icons/Images
- Included120+ WinForms Controls
- Not included100+ WPF Controls
- Not included30+ WinUI & .NET MAUI Controls
- Not included40+ ASP.NET MVC & Core Controls
- Not included40+ ASP.NET WebForms Controls
- Not included19+ Blazor Components
- IncludedData Services/Web API
- Not included80+ JavaScript Controls
- Enterprise Controls
- Not includedFinancialChart
- Not includedFlexSheet
- Not includedFlexPivot/OLAP
- Not includedFlexReport Designer
- Not includedReportViewer
- Additional Features
- Not includedIntelliSpell
- Not included2200+ Icons/Images
- Included120+ WinForms Controls
- Included100+ WPF Controls
- Included30+ WinUI & .NET MAUI Controls
- Included40+ ASP.NET MVC & Core Controls
- Included40+ ASP.NET WebForms Controls
- Included19+ Blazor Components
- IncludedData Services/Web API
- Included80+ JavaScript Controls
- Enterprise Controls
- IncludedFinancialChart
- IncludedFlexSheet
- IncludedFlexPivot/OLAP
- IncludedFlexReport Designer
- IncludedReportViewer
- Additional Features
- IncludedIntelliSpell
- Included2200+ Icons/Images
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.