Key Features | Document Solutions for Excel, Java Edition

Key Features

In This Topic

Fast, Lightweight Excel API: Use this small-footprint, high-performance spreadsheet server-side Excel-like API Library to quickly create, open, edit, convert, and share Microsoft Excel-compatible spreadsheets using Java.
Seamless Excel Compatibility: Lose nothing on import. Pivot tables, Pivot Charts, Comments, Charts, Conditional formatting, Sorting, Filtering, Grouping, Data validation, Formulas, Shapes, Pictures, Slicers, Sparklines, and Tables stay intact while enabling programmable modification. See File Operations.
Cell and Range Operations: Ability to manipulate individual cells, including setting and retrieving values, formatting, merging cells and much more. Get and set all style, formula, and other settings on cells, rows or columns in Java Excel documents. See Range Operations.
Worksheet Management: Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, protect, and add iterative calculations. See Work with Worksheets.
Formulas (450+ Excel Functions): Use hundreds of built-in functions including dynamic array formulas and operators to perform complex calculations, add external formulas, or build your own custom functions and create what you need. See Formulas.
Export to CSV, PDF, HTML and Images: Export Excel .xlsx spreadsheets to PDF, CSV, HTML, and Images with diverse options tailored to user needs. PDF Export includes security settings and embedded form controls with HTML5 tags for autocomplete. See File Operations.
Use Templates to create custom Excel reports: Leverage Templates support with comprehensive syntax and API to bind Excel documents to multiple data sources, generating advanced custom Excel reports with ease. The templates provide flexible syntax, easy notations and extended reusability making it an ideal solution to generate Excel reports. See Templates.
Flexible Themes and Components: Let users leverage the power of customizable templates, themes, configurable components, summary data, custom styles, embedded drawing objects, integrated calculation engine, and more.
Document Object Model: Based on the extensive Excel Object Model, the interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VS Tools for Office-style API, you can create custom styles using the same elements as VS Tools for Office.
Performance Optimization: Efficient algorithms and optimizations to handle large Excel files without performance degradation. Exclude empty cells, user-defined but never used cell styles or defined names and reduce the size of your workbook while saving it. Includes ImportData() function to quickly import just the data values from a specified range in an Excel file without loading the whole object model.
Error Handling: Robust error handling mechanisms to handle exceptions gracefully during file operations.
Import/Export Excel Features To/From SpreadJS: Seamless import and export of new SpreadJS spreadsheet file format (.sjs) to Excel files using Java and various Open/Save options available. See Import and Export SpreadJS Files.
Compatibility with SpreadJS: DsExcel supports SpreadJS spreadsheet features, adding more compatibility with the client-side SpreadJS product. View the complete supported features list here. In addition, the API supports more powerful and deep-level JSON I/O. Users could use JSON to interact with SpreadJS in a more flexible way. See Import and Export SpreadJS Files.
Integrate with client-side Data Viewer: Includes a JavaScript Data Viewer to open and view data documents (XLSX, CSV, SpreadJS) in web applications. Optionally allows interactive operations and display of data visualization objects using the Pro Viewer. See Document Solutions Data Viewer.
Full Java 8.0+ Support for Windows, Linux, and Mac: Develop for all Java platforms and operating systems with a single code base. Use in your apps for Java Web Applications and Java Desktop Applications.