High-Performance Java & Kotlin Excel API Library

    You have full control over your spreadsheets without relying on Excel.

    • Obtained e-Government Framework Compatibility Certification!
    • Create, load, edit, and save spreadsheets
    • Save as XSLX, PDF, HTML, CSV, JSON, image, SpreadJS file
    • Parse, convert, and share spreadsheets
    • Create custom reports using Excel (.xslx) templates
    • Deployment on Azure and AWS
    • Calculate formulas and format cells
    Download Free Trial

    Why Should I Use DsExcel Java?

    Quickly create and edit Microsoft Excel documents using the DsExcel API for Java.

    Develop powerful Java-based Excel services that work seamlessly on desktop, web, mobile, and the cloud.

    Fast Speed and Efficiency

    Our lightweight API architecture saves memory and time. Process large amounts of data in an efficient and instantaneous manner.

    Flexible Themes and Components

    Take advantage of rich user resources, including flexible customizable themes, configurable components, summary data, custom styles, drawing objects, and an integrated calculation engine.

    Developed with Java 8.0+ for Windows, Linux and Mac

    Quickly create Excel spreadsheets from cross-platform applications with an intuitive Java API.

    Deploy Your Java spreadsheets to the Cloud.

    Supports cloud-based deployment anywhere - Deploy to Azure, AWS, and AWS Lambda using Maven and DsExcel.

    Powerful Excel Compatibility

    Import pivot tables, notes, charts, conditional formatting, data validation, formulas, shapes and pictures, sparklines, and tables without loss.

    Based on Excel's Document Object Model

    The interface-based API enables import, calculation, query, creation, and export operations across all spreadsheet scenarios. The VSTO-style API uses the same elements found in VS Tools for Office to create custom styles.

    Official support for JDK 6 & 7 has ended.

    DsExcel Java also no longer supports JDK 6 & 7, and the latest version requires JDK 8 or higher.

    No More Compromising with Open Source Features.

    DsExcel supports the full range of Excel features, which is incomparable to Apaceh POI.

    Now you can import/export Excel forms without compromising on functionality or loss.

    DsExcel is 7 times faster than Apache POI and consumes less than 1/7 the memory, providing perfect performance even for processing large amounts of data.

    Ask Anything!

    Share your vague concerns and questions about DsExcel with MESCIUS's expert team. We empathize with your concerns and are here to help.

    Online Consultation

    Try DsExcel Java now.

    Click the tabs below to get new ideas through workflows for a variety of real-world situations.

    Implement export functionality that is fully compatible with Excel.

    Beyond simply exporting data, you can create and export Excel files containing charts, pivot tables, shapes, formulas, and formatting that work in real MS Excel. Translate dashboards created in HTML into Excel, allowing users to flexibly analyze their data. * Combine with Wijmo, a high-performance JavaScript data visualization control, to develop even more complete data analysis and monitoring solutions.

    Implement an Excel data collation solution quickly and easily.

    You can automate the collection of Excel data from various departments and employees through standardized forms. DsExcel provides functions that retrieve data from specific cells using the same coordinate system as Excel. This allows you to quickly save only the necessary data to the database, creating raw data.

    Convert existing Excel files into a database quickly and easily.

    Using the DsExcel API's toJson/fromJson functions, you can easily convert Excel files to JSON strings and store them in a database. The converted JSON retains all Excel features, including formatting, functions, formulas, charts, and pivots. If necessary, DsExcel can be used to extract data from specific cells and save them as raw data. This allows you to work entirely on the web, rather than in Excel files.

    Implement a service that generates regular/irregular reports.

    DsExcel allows you to save your current Excel form files for reporting on a server or convert them to JSON for database storage. After loading the Excel form file or JSON file into DsExcel, you can input the required data from the database and generate and download Excel, PDF, and HTML reports, including Excel data visualization controls.

    Use it with SpreadJS to Implement a complete Web-based Excel Solution.

    Using SpreadJS and DsExcel together provides end users with an Excel-like interface and behavior, while the backend leverages the DsExcel API to quickly process Excel data received from SpreadJS using powerful server resources. Furthermore, by performing sensitive data and Excel formula/calculation operations on the server, you can further enhance security.

    Learn More About SpreadJS

    DsExcel Java Key Features

    • AI Functions

      Support for new AI functions enables plug-and-play integration with OpenAI, Azure OpenAI, Gemini, and more.


      * AI.QUERY — Data-driven question answering

      * AI.TRANSLATE — Multilingual translation

      * AI.TEXTSENTIMENT — Sentiment analysis (Positive / Negative / Neutral)

    • Excel Import and Export

      Seamlessly import and export Excel-compatible XLSX files without relying on Excel.

    • Workbooks and Worksheets

      You can perform various tasks such as creating, importing, exporting, using passwords, adding sheets, cutting and copying ranges, copying and moving worksheets, activating, organizing, deleting, and protecting them.

    • Formulas, 450+ Excel Functions, User-defined Functions Supported

      Perform complex calculations using hundreds of built-in functions and operators, or build your own custom functions to create the formulas you need.

    • Pivot Table

      You can create an Excel data table and add a pivot table to automatically calculate, sum, or average your data.

    Ask Anything!

    Share your vague concerns and questions about DsExcel with MESCIUS's expert team. We empathize with your concerns and are here to help.

    Online Consultation

    DsExcel Java Demo

    Getting Started with DsExcel Java

    This step-by-step tutorial will guide you through coding spreadsheets using DsExcel Java right away. The tutorial will teach you various features and even provide code samples you can download and apply immediately.

    Read More

    Learning DsExcel Java by Function

    Explore the many example codes that demonstrate how to use the basic features of DsExcel Java.

    Read More

    DsExcel Java Showcase

    You can see the full code demonstrating how to create an Excel file. You'll also learn how to open an existing Excel file on the server side and update its contents.

    Read More

    DsExcel Java Template

    DsExcel introduces a new template approach, featuring a comprehensive syntax and API that allows you to bind Excel documents to data and generate advanced-looking Excel reports. With flexible syntax and simple notation for data expansion and formulas, the new template syntax and API allow you to easily define Excel templates and generate Excel reports that support a variety of use cases.

    Read More

    Create Variety Reports Through DsExcel Template Forms.

    Step 1. Create a DsExcel template

    After pre-entering the "DsExcel template syntax" above the specific Excel cells where the data will be inserted, create a form or resource folder on the server and save it. The template syntax reflects the data structure of your designed JSON or Java class.

    Step 2. Bind the data source to the template

    Load the Excel template saved in Step 1 using DsExcel's Open method. Bind JSON, DataSet, Datable, Array, and other data to the loaded form using the AddDataSource method.

    // Create a new workbook

    Workbook workbook = new Workbook();


    // Load template file named "Template_FamilyInfo.xlsx"

    InputStream templateFile = this.getResourceStream("xlsx/Template_FamilyInfo.xlsx");

    workbook.open(templateFile);


    // Get data from JSON file

    InputStreamReader reader = new InputStreamReader(this.getResourceStream("Template_FamilyInfo.json"));

    Gson gson = new Gson();

    StudentInfos datasource = gson.fromJson(reader, StudentInfos.class);


    // Add data source

    workbook.addDataSource("ds", datasource);

    Step 3. Save as Excel

    Using the ProcessTemplate function, we enter actual data into the form in Step 2, and then use the Save function to save it as an Excel file.

    // Called to process template

    workbook.processTemplate();

    

    // Save as Excel file

    workbook.save("JsonFile.xlsx");

    Run Demo

    DsExcel Java v9.1
    New features

    [New Feature Support]

    • Cell Checkbox Support : Embed checkboxes directly into cells for seamless movement during sorting, filtering, and row operations, with full support for PDF/image export and SJS·SSJSON·XLSX round-tripping
    • Picture In-Cell Support : Insert images directly into cells with server-side reading capabilities, enabling filtering and sorting based on Alt Text, and full support for PDF·HTML·image export
    • Pivot Table Dynamic Cell Style Support : Retain cell styles even after refreshing or changing layouts, improving compatibility with Excel Pivot Table formatting behavior
    • Pivot Table Field Header Show/Hide : Control row and column field headers via the IPivotTable.DisplayFieldCaptions property to build clean report and dashboard layouts
    • Waterfall Chart PDF Export Support : Includes definitions for subtotal/total points and connector lines control, also applicable to image and HTML exports
    • Shape Text Bullet PDF Export Support : Preserves the type, color, and size of symbols, automatic numbering, and custom bullets to enhance PDF output accuracy


    [Template Engine Improvements]

    Enhanced support for rich filtering expressions and SpreadJS-based template content


    • Template Filter NULL Keyword Support
    • Template Filter DATETIME Keyword Support
    • Template Filter REGEX Keyword Support
    • Template Cell SpreadJS Cell Type and Style Extension Support


    [SpreadJS Lossless I/O Enhancements]

    Enhanced lossless I/O improvements to more accurately preserve the latest SpreadJS workbook features within SJS and SSJSON workflows


    • Conditional Formatting Sparkline Rule I/O Support
    • Conditional Formatting Top/Bottom Percentage Rule Support
    • SpreadJS Scrollbar Auto Mode Support
    • DataManager Table-specific Attachment New Format Support
    • Accounting Underline Style (SingleAccounting/DoubleAccounting)
    • Support Named Cell Templates I/O Support
    Read More

    Ask Anything!

    Share your vague concerns and questions about DsExcel with MESCIUS's expert team. We empathize with your concerns and are here to help.

    Online Consultation

    DsExcel Java Video Tutorial

    Getting Started
    Add Table
    Add Sparkline
    Add Automatic Filter
    Add Pivot Table
    Add Chart

    • Getting Started

      Learn step-by-step how to create an Excel document using DsExcel Java. You'll also learn how to add features like tables, pivot tables, styles, conditional formatting, and charts to your spreadsheets.

    • Add Table

      Learn step-by-step how to add a table to a spreadsheet using DsExcel Java and set up formulas to calculate the total number of rows and the average.

    • Add Sparkline

      Learn how to add sparklines to your spreadsheet for data analysis using DsExcel Java.

    • Add Automatic Filter

      Explains how to automatically filter data in a spreadsheet using DsExcel Java.

    • Add Pivot Table

      This article explains how to add a pivot table to a spreadsheet for data analysis using DsExcel Java.

    • Add Chart

      Explains how to add a chart to a spreadsheet using DsExcel Java.

    DsExcel Java Free Trial

    Download

    Our Customers

    MYLINK

    Smart Manufacturing IT Solutions, LinkBiz

    #Distribution #Excel #Dashboard

    Ministry of Agriculture, Food and Rural Affairs

    Smart Farm R&D

    Big Data Portal

    #PublicInstitution #Excel

    Introduction Case

    Explore more MESCIUS product adoption examples.

    DsExcel Java Pricing and Licensing

    * All amounts are exclusive of VAT.

    Project License

    This license is required to use and distribute the DsExcel Java API, and requires the purchase of 1 copy per development project.

    When purchasing DsExcel Java alone,

    $1,800

    with SpreadJS,

    $1,180

    Introduction Inquiry

    If you need more detailed product or purchase consultation regarding the introduction of DsExcel Java, please contact us using a method that is convenient for you.

    Development/Deployment Key Application

    To develop and deploy using the DsExcel Java API, you must purchase a project license and obtain a development/deployment key. Please apply through the development/deployment key issuance portal.

    • DsExcel Java License Guide and Application Method (v5 or later)

    Purchase Procedure

    Click on each button to see detailed information about each step of the purchasing process.

    • 1. Price confirmation and quote request

       Please request a quotation using any of the methods below that are convenient for you.


    • 2. Order Request

      Please send the following three items to Email (asia.sales@mescius.com)


      1. Signed quotation (authorized signatory or company seal)
      2. Copy of business registration certificate (for companies)
      3. End-User information:

                1) Company Name (in English):

                2) Contact Person (in English):

                3)E-mail:



      Once your order request is received, we will issue the invoice via email.

    • 3. Payment

      Bank Transfer


      Please make the payment to the account number indicated on the invoice you received.

    • 4. License issuance & Tax invoice issuance

      After payment is confirmed, we will send you an email with license issuance details.



      *To deploy the DsExcel Java API control on a server, you must purchase a deployment license and obtain a deployment key. Please request your deployment key through the Deployment Key Portal.


      Distribution Key Issuance

    Controls for Web Developers

    • SpreadJS

      Pure JavaScript-based Web-Excel Component
      • Supports Excel import/export
      • Supports 450+ Excel functions
      • Supports Angular, React, and VueJS
      Learn More

    • Wijmo

      JavaScript-based UI Controls such as Chart, Grid, and Input
      • 80+ UI controls including grids, charts, reports, input forms, and OLAP
      • Full support for Angular, React, and VueJS
      • Filter, group, and sort functions
      Learn More

    • ActiveReportsJS

      JavaScript-based Business Reporting Component
      • Supports Angular, React, and Vue
      • Provides a designer program that supports cross-platforms
      • Provides a JavaScript report viewer
      Learn More

    • Forguncy

      Build Business Web Apps with Excel — No Coding Needed
      • Turn Excel features into fast, powerful web apps
      • Start web development — no HTML or CSS required
      • Unify and collect your business data with ease
      Learn More