• 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

  • Flexible Themes and Components

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

  • Seamless Excel Compatibility

    Lose nothing on the import or export. Documents for Excel supports pivot tables, comments, charts, conditional formatting, data validation, formulas, shapes and pictures, sparklines, and tables and much more.

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

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

  • Based on Excel's Document Object Model

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

  • Deploy Apps with Excel Spreadsheets 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 and Export Excel

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

Workbooks and Worksheets

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

Formulas (450+ Excel Functions) and Custom Functions

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

Pivot and Excel Tables

Create Excel data tables and add pivot tables to automatically count, total, or average the data

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.
Documents for Excel Demo

The demo includes a tutorial with step by step instructions to begin using Documents for Excel to code spreadsheets today. It also showcases many of the features with code samples you can download and apply now

Launch the Full Demo

Feature

Description

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.

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.

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

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

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

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

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

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

Create and use 450+ in-built functions formulas that let you calculate the value of a cell quickly and accurately. You can also use built-in functions and operators to generate formulas and calculate values in cells.

Summarise 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.

Use linear and radial gradient brushes.

Apply rich text formatting in the cells of the worksheet.

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

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

Find and replace text in Excel workbook with different options.

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

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

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

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

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.

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

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

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.

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.

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

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.

Apply hyperlinks to a range using the IWorksheet.Hyperlinks.Add or IRange.Hyperlinks.Add method. Apply hyperlinks to a shape using the IWorksheet.Hyperlinks.Add method.

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.

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.

In GcExcel, you can use the methods of IWorksheets to execute different tasks in a spreadsheet including insertion of a new worksheet in the workbook, deletion of a worksheet from the collection, assigning an active sheet, and so much more.

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 will make it easy to define Excel templates and generate Excel reports supporting numerous use cases.

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. Spread.Sheets works in the browser (client side) as a viewer or editor.

What's New

What's New in GcExcel, .NET

  • Export Excel Spreadsheets and Excel range to HTML - Export full or partial Excel spreadsheets directly to HTML files and present reports online.
  • Digital Signatures Support in Excel Spreadsheets - allows a user to digitally sign an Excel file to secure the content's authenticity.
  • Generate PDF Forms from Excel Templates - Generate fillable PDF forms from Excel templates.
  • Shape Z-order Support - allows the user to define which shape is behind or in front of others.
  • Support for Image Quality When Exporting to PDF - lets users export spreadsheets to PDFs with the highest image quality or optimized PDF file size.
  • More Features for GrapeCity SpreadJS Integration - Adds the ability to Show or Hide Horizontal and Vertical Grid Lines Separately, Custom Frozen Line Colors, Freeze Trailing Rows/Columns to improve compatibility with client-side SpreadJS products.
  • What's New Roadmap

    Resources

    Contact

    Forums (24-hour Global Support)
    Submit a ticket

    Research

    Demos
    Videos

    Get Started with Documents for Excel, .NET Edition

     

    Get Started with Windows

     

    Get Started with Mac

     

    Get Started with Linux