Overview

A .NET Excel spreadsheet API library is a programming interface that allows developers to programmatically create and manipulate Excel documents at scale. GrapeCity Documents for Excel is a solution that allows developers to import/export, create reports & templates, and deploy spreadsheets across desktop applications.

  • Fast and Efficient

    Save memory and time with the lightweight API architecture. The more rows in the spreadsheet the faster our API is by comparison. Create, read, and edit Excel files from C# with just a few lines of code.

  • Full .NET Support for Windows, Linux, and Mac

    Develop for all .NET platforms and operating systems with a single code base. Use in your apps for .NET Core, .NET Framework, Mono, Xamarin.iOS, and Xamarin Android.

  • Flexible Themes and Components

    Empower users with customizable themes, configurable components, summary data, custom styles, embedded drawing objects, integrated calculation engine, and more.

  • Document Object Model

    The interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VS Tools for Office-style API, you can create custom styles using the same elements as VS Tools for Office.

  • Seamless Excel Compatibility

    Lose nothing on import. Pivot tables, comments, charts, conditional formatting, data validation, formulas, shapes, pictures, sparklines, and tables stay intact.

  • Deploy Apps to the Cloud

    Cloud-based deployment means you can be everywhere - with NuGet and Documents for Excel, you can deploy to Azure, AWS, and AWS Lambda.

Import .NET 6 Excel API / .NET 6 Excel Library

Import and Export Excel

Seamlessly import and export Excel-compatible XLSX files with no Excel dependency

.NET 6 Excel Library Workbooks and WorkSheets

Workbooks and Worksheets

Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations.

450+ Excel Formulas and Custom Functions With Our .NET 6 Excel Library

Formulas (450+ Excel Functions) and Custom Functions

Use hundreds of built-in functions and operators to perform complex calculations, add external formulas, or build your own custom functions and create what you need

Formula Parser

Formula Parser

Create, parse and modify formulas with GrapeCity.Documents.Excel.
Expressions namespace to parse the formula expressions into syntax tree.

Range Operations for .NET 6 Excel API

Range Operations

Execute operations on cells, rows or columns in Excel documents with the help of Range property of the iWorksheet interface.

Dynamic Array Formula

Dynamic Array Formula

Use 7 new Dynamic Array Formula functions to return multiple values on a range of cells.

Formatting for .NET 6 Excel

Formatting

GcExcel provides many properties to customize the appearance of a range.

Tables in .NET 6 Excel API

Tables

Manage Tables independently in Excel worksheets, format rows & columns, perform calculations for a specific table range.

.NET 6 Excel API Forms

Forms

Create AcroForm fields, submit data forms to a server, import XML data, and import form data submitted on the client to a PDF.

Conditional Formatting in .Net 5 Excel API

Conditional Formatting

Create conditional formatting rules for individual cells or a range of cells based on cell values.

Data Validation - .NET 6 Excel Library

Data Validation

Validate data by restricting the format and values that can be entered in cells of a worksheet. Create distinct validation scenarios for individual cells or for a range of cells.

Grouping in .NET 6 Excel API

Grouping

Summarize large amounts of information in groups so that complex spreadsheets are easier to navigate. You can expand and collapse details with the click of a button in the group header row.

Graphics in NET 5 Excel API

Graphics

Use linear and radial gradient brushes.

Cell Rich Text for Excel in .NET 6 API Library

Cell Rich Text

Apply rich text formatting in the cells of the worksheet.

Custom Functions .NET 6 Excel API

Custom Functions

Create your own custom functions, allowing you to easily create any custom arithmetic logic you may need.

Data Binding in .NET 6 Excel API

Data binding

GcExcel supports one-way data binding with cell, sheet and Table binding in Excel spreadsheets.

Find and Replace in Excel in .NET 6 API Library

Find and replace

Find and replace text in Excel workbook with different options.

Image Exporting for Excel in .NET 6 API Library

Image Exporting

Explore complete code demonstrating how to export sheet/range/shape/chart to image files at server side.

Page Setup for Excel in .NET 6 API Library

Page Setup

Specify page setup attributes (left margin, bottom margin, paper size, and so on) on Excel workbook.

PDF Exporting .NET 6 Excel API Library

PDF Exporting

Export Excel .xlsx spreadsheets to PDF at server side with various PDF options.

Filtering .NET 6 Excel API Library

Filtering

GcExcel supports all types of filters which you can apply on selected range of data.

Sorting .NET 6 Excel API Library

Sorting

GcExcel provides the Sort method to perform data sorting based on a range of cells, range by value, color or icon in a worksheet. The Apply method is used to apply the selected sort state and display the results.

Charts .NET 6 Excel API Library

Charts

GcExcel provides a comprehensive charting API to add charts in Excel.

Shapes  .NET 6 Excel API Library

Shape

Embed drawing objects like shapes and pictures in the cells of a worksheet. You can insert arrows, lines, charts, slicers, pictures, and general shapes.

Pictures  .NET 6 Excel API Library

Picture

Add a picture to a worksheet, use the AddPicture method of the worksheet's Shapes collection to create, delete, cut, copy and duplicate pictures in the worksheet.

.NET 6 Excel API Library Slicer

Slicer

Slicers are visual filters that you can use to filter a table or pivot table. GcExcel supports adding both built-in and custom slicer styles in Excel workbook.

Comments .NET 6 Excel API Library

Comments

GcExcel enables users to annotate worksheets, write comments for cells to add information about the data it contains.

.NET 6 Excel API Library Pivot Tables

Pivot Table

Add pivot table to Excel workbook for data summarization, automatically count, total, or average the data stored in a spreadsheet, and display the resulting summarized data in a second table.

.NET 6 Excel API Library Hyperlinks

Hyperlinks

Export spreadsheet directly to HTML files with various Html options to preserve the formatting of Excel content into HTML files.

.NET 6 Excel API Library Themes

Theme

GcExcel provides you with a set of built-in themes so you can quickly change the overall appearance of a workbook. It also lets you create custom themes and apply them to workbooks.

.NET 6 Excel API Library Workbooks

Workbook

GcExcel provides all the necessary properties and methods required to create a workbook, perform complex operations on the data residing in the spreadsheets and make use of several workbook events that are triggered when called explicitly by the user through code.

Templates .NET 6 Excel API Library

Templates

GcExcel introduces new templates support with comprehensive syntax and API to bind Excel documents to data and generate Excel reports with advanced layouts. With flexible syntax and easy notations for data expansion and formulas, the new template syntax and API makes it easy to define Excel templates and generate Excel reports supporting numerous use cases.

SpreadJS Viewer

SpreadJS Viewer

Examples in this folder demonstrate how to use GrapeCity Documents for Excel and SpreadJS. GrapeCity Documents for Excel works on the server side to import and export Excel template files. SpreadJS works in the browser (client side) as a viewer or editor.

SpreadJS Feature Support

SpreadJS Feature Support

GcExcel adds support for SpreadJS features adding more compatibility with the client-side SpreadJS product. View complete supported features list here.

Showcase Demos for .NET 6 Excel API

Showcase

Explore complete code demonstrating how to generate an Excel file, or you may have your own Excel files and just want to open and update some of its contents at server side.

Getting Started with Documents for .NET 6 Excel API

Quick Start

In this tutorial, we create a real-life scenario with GrapeCity Documents for Excel to give you a fundamental understanding of what it can do.

Explore the Advanced Features of a Spreadsheet API

Explore the Advanced Features of a Spreadsheet API

Each main feature demo link listed below contains several demos that show how to use a particular feature. Click a link to learn more.

The demo includes a tutorial with step-by-step instructions on using Documents for Excel to code spreadsheets. It also showcases numerous API features and includes code samples you can download and apply now.

Launch The Full Demo

GrapeCity Documents is Trusted by the World’s
Leading Companies

Trusted by the World’s Leading Companies