Key Features
With a set of class libraries, collections, interfaces, pre-defined functions, properties and methods that comes packaged with GcExcel .NET; developers can quickly build everything right from the scratch to organize and structure business-critical data for maximum productivity and enhanced analysis.
GcExcel.NET provides users with the following essential features in order to facilitate developers in creating powerful spreadsheets using .Net Core:
Lightweight API Architecture for Improved Efficiency
GcExcel .NET enables users to save a considerable amount of time, storage memory and efforts by improving the overall efficiency with its lightweight API architecture that can be used to generate, load, edit, save and convert spreadsheets.
Flexible Themes and Components
For complete customization, GcExcel .NET allows you to set up custom themes, configure components, summarize data, customize styles, embed drawing objects, apply cell formatting and integrate calculation engine.
Seamless Excel Compatibility
While executing the import operation, you can include pivot tables, comments, charts, conditional formatting, data validation, filters, formulas, shapes, pictures, slicers, sparklines and tables etc. in the spreadsheets without any compatibility issues.
Extensive Support for Major Operating Systems
GcExcel .NET core applications can be deployed on all major operating systems including Microsoft Windows, Linux and macOS.
Based on Excel Object Model
The interface-based API model enables users to import data, calculate formulas, query, generate, and export complex spreadsheet scenarios as per specific preferences.
No Dependency on MS Excel
In order to work with GcExcel .NET, users don't need to install MS Office Suite and access MS Excel on their systems.
Use Built-in Templates for Simple Forms
Using built-in templates, you can quickly create simple forms like invoice etc. while working with spreadsheets.
Create Interactive Experience with SpreadJS Sheets
GcExcel .NET can be used with spreadsheets for a completely interactive and user-friendly spreadsheet experience.
Workbook and Worksheets
You can create workbook and add worksheets while also performing the import and export operations. Further, you can activate worksheets, configure its display, delete it and protect it from modification or encrypt it with a password.
Formulas and Functions
With support for implementing formulas, creating custom functions and using 450+built-in functions, you can execute complex spreadsheet calculations without any hassle.
Pivot and Excel Tables
You can create tables and pivot tables to automatically calculate the count, total or average of data in the spreadsheets. You can also rename pivot table fields, manage grand total visibility settings and change row Axis layout of pivot field.
Export to PDF
Using the export to PDF feature, users can save spreadsheets to PDF files with different page settings, features, document properties and security options. You can also export Excel sheets with charts, slicers and sheet background images.
Deploy Apps with Excel Spreadsheets to the Cloud
With GcExcel .NET, you can apply cloud-based deployments and deploy your applications on Azure and AWS Lambda.
Shapes and Pictures
With GcExcel API, you can insert and customize shapes and pictures on cells of a worksheet, apply formatting, gradient fill, configure text, insert hyperlinks, set adjustment points of the shapes, group/ungroup them in a worksheet and determine the position and size of an image.
Use Templates to create custom Excel reports
GcExcel provides templates with comprehensive API to create custom Excel reports with advanced layouts. You can use multiple data soures to bind the data. The templates provide flexible syntax, easy notations and extended reusability making it an ideal solution to generate Excel reports.
For more information on the complete list of supported features in GcExcel .NET, refer to the Features topic in the documentation.