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
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.
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.
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)
View Demo
Excel Import and Export
Seamlessly import and export Excel-compatible XLSX files without relying on Excel.
View Demo
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.
View Demo
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.
View Demo
Pivot Table
You can create an Excel data table and add a pivot table to automatically calculate, sum, or average your data.
View Demo
-
AI Functions
-
Font
-
Format
-
Graph
-
Conditional Formatting
-
450+ functions
-
Grouping
-
Cell Rich Text
-
Data Binding
-
Find and Replace
-
Image Export
-
Page Settings
-
Export PDF
-
Filter
-
Sort
-
Chart
-
Figure
-
Image
-
Slicer
-
Memo
-
Pivot Table
-
Hyperlink
-
Theme
-
Workbook
-
Worksheet
-
User-defined Function
-
Range Operations
-
Validation
-
Import Data
-
Threaded Notes
-
Linked Image
-
Print
-
Barcode
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.
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.
Learning DsExcel Java by Function
Explore the many example codes that demonstrate how to use the basic features of DsExcel Java.
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.
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.
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");
MESCIUS Developer Forum
-
DsExcel Java Blog & Tips
We provide various information to help you use DsExcel Java effectively.
-
DsExcel Java Q&A
Please share your concerns and development knowledge with us through the Q&A space.
-
DsExcel Java FAQ
You can check answers to frequently asked questions.
-
Citizen Insight
This space was created to help alleviate some of the fatigue and stress you may experience while working. Feel free to communicate freely.
-
Citizen Intellectuals
In addition to questions about MESCIUS products, this is a space where anyone can freely ask questions and communicate about development/technology.
-
IT Seminars/Meetings
This is a meeting space created for developers and those interested in development to develop together.
DsExcel Java v9.2
New features
🚀 Workbook and Excel I/O Enhancements
- Lossless XLSX Handling for Equation Shapes : Preserves original Office Math structures and Shape Format settings when opening and saving workbooks
- Custom XML Part API : Add, retrieve, enumerate, update, and remove workbook-level XML content via ICustomXmlPartCollection and ICustomXmlPart
- Hidden Defined Names (IName.Visible) : Keep helper names available to formulas and automation logic while hiding them from the Name Manager
- Form Controls Inside Grouped Shapes : Control properties and group hierarchy preserved across XLSX, SJS, and SSJSON workflows
💡 Pivot Table Grouping API Support
- Date Grouping : Group by second, minute, hour, day, month, quarter, or year with optional automatic layout placement
- Number Range Grouping : Define start, end, and interval values to replace displayed items with range-based bins
- Custom Grouping : Combine selected PivotItems into named, nestable groups
- Ungrouping : Removes grouping and restores the original layout, with round-trip support across XLSX, SJS, and SSJSON
✨ SpreadJS Interoperability and Lossless I/O
- Automatic AI Function Prefix Conversion : Converts between SJS.AI and AI prefixes during SJS and SSJSON import and export with no additional API required
- DataManager-Sourced Pivot Table Round-Trip : XLSX export and IPivotTable.Update supported when a complete PivotCache is present
- SpreadJS v19.2 Feature Preservation : Lossless I/O for Focus Cell, custom pivot subtotals, rounded cell borders, watermark background image options, and cell scenarios
✅ Additional Updates
- This release also includes configurable invalid formula handling (InvalidFormulaHandling), a CSV formula injection mitigation option, XLTX template file support in DsDataViewer, local performance benchmark packages for .NET and Java, and expanded API reference documentation.
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.
DsExcel Java Video Tutorial
DsExcel Java Blog
List of Services
-
12 Reasons Why You Should Use DsExcel Instead of Apache POIList Item 1We compare the features and performance of both products and present 12 key reasons why you should use DsExcel over Apache POI. Check out the detailed feature comparison table and performance comparison results.
-
Creating, modifying, and saving Excel spreadsheets from Java applicationsList Item 2Describes a use case for loading an existing Excel spreadsheet using DsExcel Java and formatting it with fonts, table styles, cell styles, etc.
-
How to Convert Excel Sheets to PDF in JavaList Item 3Let's learn how to load an Excel spreadsheet in Java and then convert it to PDF using DsExcel Java.
DsExcel Java Free Trial
Purchase Procedure
Click on each button to see detailed information about each step of the purchasing process.
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
