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

  • Develop in Java 6.0+ for Windows, Linux, and Mac

    Create lightning-fast spreadsheets in cross-platform apps with this intuitive Java API.

  • 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 VSTO-style API, you can create custom styles using the same elements as VS Tools for Office.

  • Seamless Excel Compatibility

    Lose nothing on the 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 maven, gradle, and Documents for Excel, you can deploy to Azure, AWS, and AWS Lambda.

Import Java Excel API / Java Excel Library

Import and Export Excel

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

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

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

450+ Excel Formulas and Custom Functions With Our Java 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 Java Excel API

Range Operations

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

Numerous Fonts |  Java Excel API Library

Fonts

Create, initialize and use the FontCollection class to manage and use when rendering texts to PDF documents.

Formatting for Java Excel

Formatting Cells

GcExcel provides many properties for fill, borders, and formatting to customize the appearance of a range.

Tables in Java Excel API

Tables

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

Conditional Formatting in Java Excel API

Conditional Formatting

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

Data Validation - Java Excel Library

Data Validation

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.

Formulas Java Excel API Library

Formulas

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.

Grouping in Java Excel API

Grouping

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.

Cell Rich Text for Excel in Java API Library

Cell Rich Text

Apply rich text formatting in the cells of the worksheet.

Custom Functions Java Excel API

Custom Functions

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

Data Binding in Java 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 Java API Library

Find and replace

Find and replace text in Excel workbook with different options.

Image Exporting for Excel in Java 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 Java API Library

Page Setup

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

PDF Exporting Java Excel API Library

PDF Exporting

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

Filtering Java Excel API Library

Filtering

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

Sorting Java 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 Java Excel API Library

Charts

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

Shapes  Java 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  Java 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.

Java 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 Java Excel API Library

Comments

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

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

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

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. Spread.Sheets 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 Java 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 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.

Documents for Excel Demo

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

Try Full Demo

GrapeCity Documents is Trusted by the World’s
Leading Companies

Trusted by the World’s Leading Companies