High-performance Java & Kotlin Excel API library

List of Services

    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, or SpreadJS file
    • Parse, convert, and share spreadsheets
    • Create custom reports using Excel (.xslx) templates
    • Deployment on Azure and AWS
    • Calculate formulas and format cells
    • Various features added v8.1 Released!
    Start your free trial Developer Forum (Technical Support)

    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 on 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!

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

    Online product consultation Developer Forum (Technical Support)

    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

    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.

    Supports formulas, over 450 Excel functions, and user-defined functions.

    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!

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

    Online product consultation Developer Forum (Technical Support)

    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.

    See more details

    Learning DsExcel Java by Function

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

    See more details

    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.

    See more details

    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.

    See more details

    Create a variety of reports using 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"
    );

    Running the demo

    DsExcel Java v8.1
    New features

    • Support for the HtmlSaveOptions.CellAttributeOptions property
    • Add cell address properties to Excel tables exported to HTML
    • Added ability to duplicate Excel workbooks
    • Improved VLOOKUP and UNIQUE function performance
    • Enhanced features for SpreadJS compatibility
    • data chart
    • Data charts within report sheets
    • Data manager tables can be bound to data sources.
    • SpreadJS DataRange support
    See more new features

    Ask anything!

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

    Online product consultation Developer Forum (Technical Support)

    DsExcel Java Video Tutorial

    Getting started
    Add a table
    Add a sparkline
    Add an automatic filter
    Add a Pivot Table
    Add a 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 a 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 a sparkline

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

    • Add an automatic filter

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

    • Add a Pivot Table

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

    • Add a chart

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

    DsExcel Java Free Trial

    Download

    Our Customers

    My Link

    Smart manufacturing IT solutions,

    LinkBiz

    #Distribution #Excel #Dashboard

    Ministry of Agriculture, Food and Rural Affairs

    Smart Farm R&D

    Big Data Portal

    #PublicInstitution #Excel #BigDataAnalysis

    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,

    ￦2,515,000

    When used with SpreadJS,

    ￦1,650,000

    FAQ & Blog

    • DsExcel Java License Guide and Application Method (v5 or later)
    • Why Use DsExcel Instead of Apache POI
    • How to Convert Excel Sheets to PDF in Java
    • How to create a custom report using an Excel (.xslx) template in Java

    Introduction Inquiry

    Check online quotes and request quotes

    Request for product purchase consultation

    sales-kor@mescius.com

    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.

    1670 - 0583

    Application for issuance of development/distribution key

    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

    • You can request a quote using any of the methods below:
    • Online quote confirmation and quote request
    • 1670-0583
    • sales-kor@mescius.com

    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
      Find out

    • Forguncy

      A business web development solution built with Excel without coding.
      • Easy and quick web implementation with Excel features
      • Web development without HTML & CSS
      • Data collection and integration solution
      Learn more