Document Solutions for Excel, Java Edition Features

• Generate, load, edit, parse, and save spreadsheets - Facilitate fast server-side spreadsheet generation, manipulation, and serialization. Supports saving/outputting to varies file formats including XLSX, CSV, PDF, HTML, and more.
• Calculate Excel-like formulas - With support for implementing formulas, creating custom functions, and using 450+built-in functions, you can execute complex spreadsheet calculations without any hassle.
• Embed charts, images, and graphics - Create or delete Excel-like charts, add images, and draw graphics programmatically within an Excel spreadsheet with this server-side API.
• Convert Microsoft Excel spreadsheets to PDF, HTML, and image files - Convert Excel files on the server side with various PDF, HTML, and image options.
• Use templates to create custom Excel XLSX reports - With this comprehensive API, create custom Excel reports with advanced layouts and use multiple data sources to bind the data.
• Lightweight API Architecture for Enhanced Efficiency - DsExcel Java possesses an extremely lightweight API architecture that allows users to save significant amount of time, storage space and development efforts while also maximizing the overall efficiency of generating, loading, editing, exporting and converting spreadsheets.
• Flexible themes and components - Empower users with customizable themes, configurable components, summary data, custom styles, embedded drawing objects, integrated calculation engine, and more.
• Seamless Excel compatibility - Lose nothing on the import: pivot tables, comments, charts, conditional formatting, data validation, formulas, shapes and pictures, sparklines, and tables stay intact.
• Develop in Java 8.0+ for Windows, Linux, and Mac - Create lightning-fast spreadsheets in cross-platform apps with this intuitive Java API.
• Based on Excel's document object model - The interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VSTO-style API, you can create custom styles using the same elements as VS Tools for Office.
• Deploy apps with Excel spreadsheets to the cloud - Be everywhere with cloud-based deployment - with Maven and Documents for Excel, you can deploy to Azure, AWS, and AWS Lambda.
• Create and Modify Excel XLSX Workbook and Worksheets - Create Excel XLSX workbooks and add worksheets while also performing import and export operations. Further, you can activate worksheets, configure their display, add or delete elements, and protect it from modification or encrypt it with a password.
• Pivot and Excel Tables - Create tables and pivot tables to automatically calculate the count, total, or average of data in the spreadsheets. You can also rename pivot table fields, manage grand total visibility settings and change the row Axis layout of the pivot field.
• Document Solutions Data Viewer, a cross-platform JavaScript Viewer for data documents
  • Allow users open and view data documents in your web applications.
  • Load Excel (XLSX), CSV, and other file types, all in one viewer.
  • Extensive support for Excel features.
  • Works in all modern browsers and frameworks, including Edge, Chrome, Firefox, Opera, Safari, .NET, React, Preact, Angular, and Vue.
  • Option to upgrade to the Professional Data Viewer license to support interactive operations and display of data visualization objects.

Document Solutions Data Viewer (DsDataViewer)

• Standard Viewer License - All standard DsDataViewer features allow data view functionalities including:
  • Open local or remote XLSX, CSV, SpreadJS (SSJSON and SJS) documents.
  • Zoom in and out, scrollable data content.
  • View group outline and frozen pane.
  • Resize or Autofit rows and columns.
  • Select cells, copy data to clipboard and view data aggregations.
  • Show/Hide Notes.
  • Customize toolbar buttons to hide or reorder.
  • Display viewer in different themes.
  • Display Table, Sparkline/SparklineEx, Databars, and Iconsets.
  • Display the conditional format result, formula result, data formats, data validation values in cells/grid.
  • Display object style and cell gridlines.
  • Display hidden sheets.
  • Display hyperlink and allow navigation.
  • Support keyboard accessible grid operations.
• Professional Viewer License - Professional license includes all features of the Standard License and additionally includes interactive operations and display of data visualization objects as described below:
  • Filter and sort data using arrow in a Range or Table.
  • Filter and sort data using Slicer in Table and Pivot Table.
  • Display Chart, Shape, and Picture.
  • Display Barcode results of SpreadJS Barcode Formula.
  • Allow navigation on Shape and Picture object.