High-Speed Java Excel Spreadsheet API Library

Programmatically create, edit, import, and export Excel spreadsheets in your Java applications. Deploy nearly anywhere.

Create, load, edit, and save Excel .xlsx spreadsheets
Save to XLSX, PDF, HTML, CSV, JSON, Images, and SpreadJS files
2x+ faster and less memory than Apache POI
No dependencies on Microsoft Excel
Includes a JavaScript Data Viewer to view and optionally interact with data documents on the client

Download Free Trial (V 9.2.2) Request A Demo

Missed CodeClinic Live? Watch the replay and learn how to bring Intelligent PDF Automation to your .NET apps! Watch Now ≫

Java Excel API Library Overview

Document Solutions for Excel Java (DsExcel Java) allows developers to load, create, modify, calculate, save, and convert Excel spreadsheets at scale. Read and write .XLSX files, create and share reports with defined templates, and deploy spreadsheets across 8.0+ Java applications.

Build faster, give your AI coding assistant access to MESCIUS docs, APIs, and code examples — explore the MESCIUS MCP Server →

Ultimate Java Excel Spreadsheet API Library Solution

Generate .xlsx Files using a Java Excel API

Advanced API Features for Seamless Spreadsheet Management

Based on the powerful Excel Object Model, this feature-rich API enables seamless creation, editing, conversion, and export of Excel files in Java. It supports formulas, charts, pivot tables, data validation, styling, and high-performance processing for enterprise applications

Build Professional Excel Reports Using .XLSX Template in Java

Define Excel templates in Java to automate and quickly generate comprehensive .xlsx reports such as invoices, sales reports, receipts, shipping labels, purchase orders, and more. Bind data from multiple data sources, create reports using chart templates, sparklines, tables, while also supporting Microsoft Excel formulas for fast data calculation and conditional formatting.

Build Professional .NET Excel Reports Using .XLSX Template

Cross-Platform Java Development: Write Once, Run Anywhere

With full support for Windows, Linux, and macOS, you can create Excel-compatible spreadsheet applications using a single Java codebase. Document Solutions for Excel Java works seamlessly in desktop and web apps, with no dependency on Microsoft Excel. Create, load, edit, calculate, and export spreadsheets in Java, and deploy locally or to the cloud—compatible with platforms like Azure, AWS, and AWS Lambda

Learn More About the Java Excel’s API Compatibility

Complete Client-Server Spreadsheet Solution

Document Solutions for Excel also includes a client-side Data Viewer, a JavaScript component that allows developers to build cross-platform web applications to view Excel .xlsx, CSV, SpreadJS, Arrow, and Parquet data files across browsers. The optional Professional Viewer additionally includes interactive operations and the ability to display data visualization objects.

Note - for advanced client-side editing functionality, developers can use the separate SpreadJS JavaScript spreadsheet to provide a complete Excel-like editing experience on the client. Changes can then be sent back down to the server for any further processing using Document Solutions for Excel.

JavaScript Client-Side Data File Viewing and or Advanced Spreadsheet Editing Controls

See Why More Developers Are Switching From Aspose!

See Our Comparison Guide

Java Excel API Features

Create XLSX from Scratch

Create a new Excel workbook from scratch and save it as an XLSX file using Java, ideal for automating Excel file generation in Java applications.

Import/Export Excel .xlsx using a Java Excel API

Open & Save Workbook

Easily open and save workbooks in various formats.

Custom Data-Bound Excel Reports

Generate customizable, data-bound Excel reports that are dynamically populated with live data, enabling easy creation of tailored, real-time reporting solutions within your application.

Programmatically Manage XLSX Worksheets - Add, Delete, Move, & Copy

Worksheet Management

Manage worksheets within a workbook by adding, deleting, copying, and protecting sheets, along with advanced capabilities for organizing and securing data.

Data Binding

Bind various data sources such as JSON, DataTables, or custom objects to worksheets, cells, or tables in Excel spreadsheets, enabling dynamic, real-time data integration for reports.

Form Controls

Add interactive form controls to Excel worksheets, such as buttons, checkboxes, dropdowns, and more, enabling user input and data manipulation directly within the workbook.

Themes & Colors

Customize the appearance of Excel workbooks by applying built-in or custom themes and color schemes, enhancing readability and visual appeal.

Programmatically Convert Workbooks to Formats Including: PDF, CSV, JSON, PDF, SJS, HTML, IMG

File Operations

Perform a variety of file operations including importing, exporting, and converting Excel workbooks to multiple formats such as .xlsx, .csv, .json, PDF, and more.

Import and Export .xlsx from Java applications

Import/Export XLSX

Import and export Excel .xlsx files from your Java application, allowing users to load and save workbooks with full control over data, formatting, and structure.

Import, Convert, and Export CSV in Java Applications

Import/Export CSV

Enables seamless CSV file import and exporting using the Java Excel API; supporting advanced open and save options.

Import/Export JSON Stream

Importing and exporting JSON streams for workbooks and worksheets, enabling seamless integration with SpreadJS.

Import and Export JSON Stream Documentation

Export to PDF

Export Excel workbooks, worksheets, or selected data to high-quality PDFs with customization options.

Save HTML to an Excel File using a Java Excel API Library

Export to HTML

Easily export workbooks, worksheets, or specific ranges to HTML with customizable formatting.

Import Data

Effortlessly import data from collections, arrays, tables, or entities into a Java server-side Excel worksheet.

Import DataTable

Easily import DataTable objects into a Java Excel worksheet. Define table columns, populate data, and insert it into a spreadsheet for seamless data management.

Import Data From Existing Excel Files into Java Applications

Import Portions of Data from Existing Files

Quickly import only data from a Java worksheet, table, or cell range without loading the entire Excel file using Java.

Convert Excel worksheets, cells, and shapes to images using Java

Convert to Image

Convert Java Excel worksheets, cell ranges, and shapes to images in PNG, JPG, SVG, or GIF format.

Import and export Excel Macros .xlsm using Java

Import/Export Macros .xlsm

Import and export macro-enabled Excel files (.xlsm) while preserving macros, form controls, and ActiveX controls.

Import/Export to SpreadJS Files .sjs

Easily import and export SpreadJS files (.sjs, .ssjson, JSON), using Java, while preserving complex spreadsheet structures and features.

Import and Export Excel Template file .xltx using Java

Import/Export Excel Templates .xltx

Easily import and export Excel template files (.xltx) to streamline spreadsheet creation and reuse predefined layouts.

Convert Excel Templates .xltx to PDF

Convert .xltx templates to interactive PDF forms (AcroForms) while preserving checkboxes, dropdowns, and option buttons for user interaction.

Create and Delete Excel Charts using Java

Create & Delete Charts

Easily create and delete charts in Excel worksheets, providing dynamic visualizations with customizable data ranges and chart types.

Column & Bar Charts

Create dynamic column and bar charts to visually compare and present data in Excel, supporting various chart types like stacked, clustered, and 3D options.

Create Line Charts With Java XLSX API Example

Line & Area Charts

Generate line and area charts to visualize trends over time, allowing for smooth data comparison and analysis in Excel with customizable styles and data ranges.

Programmatically Created XLSX Pie Chart Example

Pie & Donut Charts

Create visually engaging pie and donut charts to represent proportions of a whole, with options for customizing slices, labels, and chart styles in Excel.

Scatter & Bubble Charts

Create scatter and bubble charts to display relationships between data points, with support for customizing axis ranges, chart styles, and bubble sizes.

Combo Charts

Create combo charts by combining multiple chart types (e.g., column, line) in one visualization to highlight different data series with varied chart styles.

Statical Charts

Visualize and interpret statistical data with built-in support for Box and Whisker, Histogram, Waterfall, and Pareto charts.

Specialized Charts

Create specialized charts like radar, surface, and treemap charts to represent complex data in unique, insightful ways that enhance data interpretation and analysis.

Pivot Charts

Create pivot charts to visualize aggregated data from pivot tables, enabling dynamic data exploration and interactive reporting within Excel.

Sparklines

Insert sparklines into Excel worksheets to display compact, mini charts within cells, providing a quick visual summary of data trends and patterns.

Shapes & Pictures

Add and manipulate shapes and pictures within Excel worksheets, enhancing document presentation with customizable graphics, logos, and visual elements.

Conditional Formatting

Apply conditional formatting to Excel cells, allowing dynamic styling based on data values, such as color scales, data bars, or icon sets, to improve data visualization.

Create Tables

Create and manage structured tables in Excel, allowing for efficient organization, sorting, filtering, and formatting of large datasets.

Table Slicers

Add slicers to Excel tables for interactive filtering, allowing users to easily control data visibility and improve analysis with visual filtering tools.

Pivot Tables

Create and manipulate pivot tables to summarize and analyze large datasets, enabling users to dynamically explore and visualize data in Excel.

Pivot Slicers

Add slicers to pivot tables for intuitive and interactive data filtering, enabling users to quickly adjust data views and improve analysis.

Grouping & Subtotaling

Group rows or columns and apply subtotals to organize large datasets, improving navigation and analysis in Excel worksheets.

Advanced Sorting

Perform advanced sorting on Excel data, including sorting by values, colors, fonts, or icons, for enhanced data organization and analysis.

Custom Filters

Apply custom filters in Excel to refine data views based on specific conditions such as numbers, text, dates, colors, and icons.

Create What-If Analysis in Excel server-side apps using Java

What-If Analysis (Goal Seek, Scenario Manager)

Perform What-If analysis using tools like Goal Seek and Scenario Manager to model different outcomes and find the necessary input values for a desired result.

Tracing Precedents/Dependents in Excel Programmatically Example

Error Checking & Tracing Precedents/Dependents

Trace and identify precedent and dependent cells in Excel to analyze formulas and troubleshoot errors in worksheets.

Precedents and Dependents Documentation

Set Cross-Sheet References and Linking in XLSX

Cross-Sheet References & Linking

Link data across multiple workbooks with cross-workbook formulas, enabling users to reference and update values from external Excel files.

Java Excel Formula Support in Server-Side Generated File

Formulas (450+ Excel Functions)

Leverage hundreds of built-in functions and operators for complex calculations, external formulas, and custom functions tailored to your needs.

Create Custom Functions

Custom functions allow you to easily create new calculation functions for use in cell formulas using custom logic to return a value in your Java app.

Set Dynamic Formulas using Java Excel API

Set Dynamic Array Formulas

Use dynamic array formulas to perform multiple calculations across a range of cells, allowing for efficient data manipulation and results display in Excel.

Iterative Calculation

Enable iterative calculation in Excel to repeatedly calculate formulas until a specific condition is met, such as a set number of iterations or a desired result difference.

Formula parsing options in Java generated Excel File

Formula Parse & Parse Format Options

Parse and format Excel formulas using a syntax tree, offering control over the conversion of formulas between A1 and R1C1 reference styles and enabling in-depth formula manipulation.

Formula Tracing

Trace formula dependencies in Excel by identifying precedent and dependent cells, helping users understand the flow of data and diagnose issues in complex formulas.

Cross Workbook Formula

Use cross-workbook formulas to reference and perform calculations on data from external Excel workbooks, facilitating dynamic and linked data across multiple files.

Localized Formulas

Set and retrieve formulas in Excel that automatically adjust to local language conventions, ensuring correct function names based on the user's regional settings.

Defined Names

Defined names simplify formulas by assigning names to tables, ranges, and constants, making calculations easier to read and manage.

Set Table Formula

Set and apply structured table formulas in Excel to dynamically reference and calculate data within tables using custom column names and row specifiers.

Pivot Table Formulas

Apply custom calculations to pivot table fields using built-in functions and manage the visibility of totals and layout options for enhanced analysis.

Asynchronous Functions

Enhance performance by running functions asynchronously, enabling multiple calculations to occur concurrently without blocking other tasks.

Linked Picture

Create dynamic, real-time snapshots of Excel ranges that automatically update when the original data changes, ideal for dashboards and reports.

Parse Values to Text

Converts values, arrays, or cell references into text, helping normalize mixed data types for concatenation, inspection, or further processing, with options for concise or formula-compatible output.

Parse Arrays to Text

Converts an array or range into a single text string, preserving Excel-compatible formatting with an option for strict, formula-ready output.

Programmatically Ignore Errors in Java generated .xlsx

Ignore Errors in Excel

Prevent the display of error indicators, like the green triangle, in Excel cells by ignoring specific types of errors in a given range.

Excel Calculation Mode

Control Excel’s calculation behavior by selecting between automatic, semiautomatic, and manual modes to optimize performance, especially with large workbooks or when exporting data.

Cell Types

Enhance spreadsheet interactivity with button, checkbox, combo box, and hyperlink cell types for custom user interactions.

Range Template Cell

Use Range Template cells to apply structured, reusable layouts to multiple cell ranges while binding data dynamically.

Data Validation

Ensure data accuracy in Excel files by programmatically applying validation rules that restrict input formats, set value ranges, and display error messages.

Set Excel Cell Styles Using a Java Excel API

Set Styles for Cells

Customize cell styles using this Java Excel API, including fill styles, fonts, borders, alignment, and number formats.

Programmatically Merge Excel File Cells using Java

Merge Cells

Combine multiple cells into one using the Java Excel API, preserving only the top-left cell’s data.

Auto Merge Cells

Automatically merge adjacent cells with identical content when exporting spreadsheets to various formats, improving readability.

Protect Cell Range

Secure worksheet data by locking specific cell ranges or hiding formulas, ensuring controlled access and data integrity.

Hyperlinks

Insert and manage hyperlinks in Excel workbooks to reference external files, web pages, email addresses, or specific locations within a workbook.

Barcodes

Generate and display barcodes in spreadsheet cells, supporting various barcode types and conversion to images for enhanced document processing.

Rich Text in Cells

Apply rich text formatting in spreadsheet cells to customize font styles, colors, sizes, and effects for enhanced data presentation.

AI.QUERY

The AI.QUERY function lets you query an AI model directly from Excel-style formulas by combining prompts and cell data, returning AI-generated results back into the worksheet as spill ranges.

AI.TRANSLATE

The AI.TRANSLATE function uses an AI model to translate text in cells or ranges into a specified target language, returning the translated results directly into the worksheet as spill ranges.

AI.TEXTSENTIMENT

The AI.TEXTSENTIMENT function analyzes text in cells or ranges using an AI model and classifies the sentiment as positive, negative, or neutral, returning customizable result values directly into the worksheet.

Excel Templates

Create reusable, data-driven Excel reports using the API’s Excel template support with dynamic data binding.

Comments

Add, format, and manage comments in spreadsheets to provide context and annotations without cluttering cells.

Programmatically Find and Replace Excel Data using Java

Find & Replace Data

Easily locate and update data across large spreadsheets using this Java Excel API’s find and replace functionality, supporting values, formulas, and formatting.

Digital Signatures

Digitally sign Excel spreadsheets using the Java Excel API to ensure document authenticity. Add visible or invisible signatures, verify signatures, and manage signature lines within worksheets.

Print

Customize page layout, orientation, and print ranges in your Excel spreadsheets with full control using this Excel Java API.

Generate Paginated .xlsx Reports using a Java Excel API Library

Generate Paginated Spreadsheet Reports

Generate paginated spreadsheet reports using Java to create structured, multi-page templates for invoices, catalogs, and other reports.

Client-Side Data File Viewer

Includes a JavaScript-based client-side viewer for previewing data files, including XLSX, CSV, ARROW, PARQUET, and SpreadJS formats.

Programmatically Store, retrieve, update, and manage custom XML data within Excel workbooks using Java

Custom XML Parts

Store, retrieve, update, and manage custom XML data within Excel workbooks for application-specific metadata, integration, and structured data workflows.

Java Excel API Library Quick Start Guide

Quick Start Guide
1. Download the Latest DsExcel Java Release .jar file.	Download Release Here or from MVN Repository - DsExcel Java
2. Install/Add the Java Excel API package and dependencies, then import the namespaces.	`import com.grapecity.documents.excel.; import com.grapecity.documents.excel.drawing.;`
3. Create a new Java Excel workbook using the Workbook class and add content using the IRange interface.	`Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").value = "Hello World"`
4. Save the Java Excel workbook to a local Excel (XLSX) using the save method.	`workbook.save("DsExcelGenerated.xlsx");`

Learn more with our complete quick start guide for Document Solutions for Excel Java.

Easy Licensing & Distribution

Access your Document Solutions Distribution Key(s) through your MESCIUS account after purchase.

Licensing FAQs

Document Solutions offers flexible tiered licensing options for single-location, multi-location or cloud use, and individual and team licenses.

Learn More About Licensing

Request a Trial Key

Our sales team can provide 30-day trial Distribution Keys for Document Solutions for Excel and the JavaScript Data Viewer, Document Solutions Data Viewer, upon request, allowing you to deploy our APIs during your trial period.

Contact Our Sales Team

Have Questions? We're Here to Help

Email us.sales@mescius.com to discuss your project needs with our product specialists or request a personalized demo with the Product Manager.

Contact Support

Trusted by the World's Leading Companies

Company names and logos are trademarks of their respective owners. Their display is for identification purposes only and does not imply endorsement of or affiliation with MESCIUS.

"The speed to build what we needed and the level of ease of use of controls are why we chose GrapeCity [now known as MESCIUS]. It was a perfect fit."

Spiro Skias - CGI