High-Speed Java Excel Spreadsheet API Library
Command total control of your spreadsheets—with no dependencies on Excel
- Generate, load, edit, and save spreadsheets
- Parse, convert, and share spreadsheets
- Create custom reports using Excel (.xlsx) templates
- Embed charts, images, and graphics in Excel docs
- Convert Excel spreadsheets, Excel ranges to PDF and image files
- Deploy to Azure and AWS
- Calculate formulas and format cells
- No Excel dependencies required
-
Fast and Efficient
Save memory and time with the lightweight API architecture. The more rows in the spreadsheet, the faster our API is by comparison
-
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 6.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 Custom Reports using Excel (.xlsx) Templates
Define Excel templates to automate and generate comprehensive Excel reports such as invoices, sales reports, receipts, shipping labels, purchase orders and more.
Learn MoreExcel Chart Templates
Now bind Excel Charts with data by defining the Chart template for the series data.
Learn MoreExport Excel Objects to Image Formats
Export Worksheet, range, chart or shape to image format.
Learn MoreSupport Password-Protected Workbooks and Worksheets
Prevent users, without having the password, to view hidden worksheets, add, move, delete, hide, or rename worksheets in Excel spreadsheets.
Learn MoreAnalyze, Calculate, and Visualize
Create matrix-like spreadsheets complete with calculations, figures, sparklines, tables, and color themes
Try the MatrixUse Built-In Templates for Simple Forms
Quickly create simple forms, like invoices, with one of our built-in templates
Get the TemplateCreate Interactive Experiences with SpreadJS
Create templates using Documents for Excel. Front-end and back-end users can fully interact with spreadsheets.
Try the DemoGenerate Team To-Do Lists
Use databars, filters, validations, and styles to create an interactive to-do list in your apps
Try the To-Do listApply Themes and Cell Formatting
Include themes, cell formatting, tables, sorting, shapes, pictures, pivot tables, and more in your spreadsheet apps
Get the Movie ListRender Excel Ranges Inside PDF
Extract range of data from Excel using the PrintManager class and print it to PDF in combination with the GcPdf API
Import and Export Excel
Seamlessly import and export Excel-compatible XLSX files with no Excel dependency
Workbooks and Worksheets
Create, import, export, use passwords, add sheets, cut and copy ranges, copy and move worksheets, activate, configure, delete, and protect
Formulas, 450+ Excel Functions, and Custom Functions
Use hundreds of built-in functions and operators to perform complex calculations—or build your own custom functions and create what you need
Pivot and Excel Tables
Create Excel data tables and add pivot tables to automatically count, total, or average the data
Try the Document API Demos
Demos
Documents for Excel Demo
The demo includes a tutorial with step by step instructions to begin using Documents for Excel to code spreadsheets today. It also showcases many of the features with code samples you can download and apply now
- Range Operations
- Access cells, rows and columns in a range
- Access areas in a range
- Access a range
- Use CellInfo helper class
- Paste options of copy
- Cut or copy ranges
- Cut or copy range between workbooks
- Get used range features
- Get row and column count
- Get used range
- Hide rows and columns
- Insert or delete cells
- Insert or delete rows and columns
- Merge cells
- Set java 8 date time value
- Set values to a range
- Set row height and column width
- Add image to a specific range
- Support Outline Column
- Formatting
- Alignment
- Set horizontal and vertical alignment
- Rotate cell contents
- Shrink to fit
- Set text orientation
- Wrap text
- Borders
- Add borders to cell
- Add borders to range
- Cell type
- Button cell type
- Checkbox cell type
- Combobox cell type
- Hyperlink cell type
- Set cell type for row/column
- Set cell type for the sheet
- Fill
- Set linear gradient fill
- Set pattern fill
- Set rectangular gradient fill
- Set solid fill
- Fonts
- Set font color
- Set font effect
- Set font name
- Set font size
- Set font style
- Set font underline
- Number Format
- Set custom number format
- Set date and time format
- Set number format
- Protection
- Hide formula
- Lock range
- Apply style to range
- Create custom style
- Create and modify style based on a style
- Get display format
- Tables
- Access each table range
- Add a custom table style
- Apply built-in styles to tables
- Create a table
- Insert or delete table rows and columns
- Perform calculations in the table
- Remove table
- Filter table range
- Sort table range
- Cell Rich Text
- Use IRichText interface
- Use Character method
- Configure text run's font
- Custom Function
- MyAddFunction
- MyConcatenateFunction
- MyConditionalSumFunction
- MyIsErrorFunction
- MyIsMergedRangeFunction
- MySumFunction
- Find and Replace
- Find (Basic usage)
- Find (With cell format)
- Find (Options combination)
- Find (Match byte)
- Find (Enumerate all occurrences)
- Find (Look in different places)
- Replace (Basic usage)
- Replace (With wrap search)
- Replace (With options)
- Page Setup
- Configure even page header footer
- Configure first page header footer
- Configure first page number
- Configure page header footer
- Configure page center
- Configure page margins
- Configure page order
- Configure page orientation
- Configure paper scaling
- Configure paper size
- Configure print area
- Configure columns to repeat at right
- Configure rows to repeat at bottom
- Configure columns to repeat at left
- Configure rows to repeat at top
- Configure sheet print settings
- Sorting
- Sort list by custom parameter
- Sort by font color
- Sort by icon
- Sort range by content
- Sort range by value
- Export pivot table
- Export fills
- Export sheet background image
- Export slicers
- Export sparklines
- Export table
- Save workbook to PDF
- Save worksheet to PDF
- Set document properties for PDF document
- Set font's folder
- Set security options for PDF document
- Shrink to fit for wrapped text
- Pivot Table
- Set field's summarize function
- Create pivot tables
- Filter items in pivot tables
- Grand total visibility
- Modify pivot field subtotal type
- Refresh pivot table
- Change row axis layout
- Set built-in pivot style
- Set custom pivot style
- Set number format for Fields
- Rename a pivot field
- Set if some style would be showed
- PDF Exporting
- Export Shape
- Basic shapes
- Custom shapes
- FlowChart
- Do not print shapes
- Shape with line format
- Shape with picture or texture fill
- Shape with rotation
- Shape with text
- Page setup
- BestFit row & column
- Black & white
- Draft
- Header footer
- Orientation
- Page breaks
- Page order
- Page settings
- Pagination
- Print area
- Print page range
- Print Tails
- Print titles
- Scaling
- PrintManager
- Custom pageInfos
- Render sheet ranges inside a pdf(Basic usage)
- Keep together certain data
- Repeat different headers in different pages
- Print multiple pages to one page
- Print specific pages
- Render sheet ranges inside a pdf(Advanced usage)
- Save multiple workbooks to one pdf
- Export text
- Cell rich text
- Export number formats
- Export overflow text
- Export font effects
- Export vertical text
- Convert Excel file to PDF
- Convert range to image
- Convert shape to image
- Convert sheet to image
- Export borders
- Export conditional formatting
- Export picture
- Export Chart
- Axis Label number format
- Axis Display unit
- Error bars
- Sunburst chart
- Treemap chart
- Trendline
- Export shape
- Shape with text alignment
- Print Manager
- Get horizontal or vertical Pagination info
- Export outline column
- Print transparent cell
- Save background pictures to PDF
- Set PickTrayByPDFSize option for PDF document
- Conditional Formatting
- Create average rule
- Create cell value rule
- Create data bar rule
- Create expression rule
- Create icon set rule
- Create multiple rules for a range
- Create three color scale rule
- Create top bottom rule
- Create two color scale rule
- Create unique rule
- Delete conditional format rules
- Data Validation
- Create custom validation
- Create date validation
- Create decimal validation
- Create list validation
- Create text length validation
- Create time validation
- Create whole number validation
- Delete validation
- Modify validation
- Formulas
- Precedents & dependents
- Dependents
- Get all the precedents
- Precedents
- Add custom names
- Set workbook's reference style
- Dirty and Calculate methods
- Use array formulas
- Use table formulas
- Grouping
- Add subtotal
- Add subtotal (with advanced options)
- Clear outline
- Collapse group
- Create range group
- Remove subtotals
- Show specific level group
- Ungroup range
- Filtering
- Date Filter
- Filter date dynamically
- Apply date filter
- Filter by color
- Filter by automatic font color
- Filter by cell color
- Filter by font color
- Filter by no fill
- Filter by icon
- Filter by icon
- Filter by no icon
- Number Filter
- Apply number filter
- Text Filter
- Apply text filter
- Change worksheet filter range
- Clear worksheet filter
- Apply multiple value filter
- Reapply filter
- Data Binding
- Sheet binding
- Bind to a sheet automatically
- Bind DataTable to a sheet
- Bind to a sheet
- Table binding
- Bind custom object
- Bind Data set
- Cell binding
- Convert Worksheet, range, shape to image
- Convert range to image
- Convert the shape to image
- Convert range to image from existing file
- Convert the shape to image from existing file
- Convert sheet to image from existing file
- Sparklines
- Clear the sparkline group
- Clear sparklines
- Configure sparkline settings
- Create sparklines
- Group exist sparklines
- Use date axis
- Charts
- Axis
- Configure axis title style
- Configure category axis style
- Set data axis units
- Configure display unit label style
- Configure gridline style
- Set tick mark label style
- Configure value axis style
- Set value axis units
- Set value axis scale type
- Configure axis tick mark layout
- Chart 3D format
- Configure chart 3D format
- Configure chart back wall
- Configure chart floor style
- Configure chart side wall
- Configure chart walls style
- Chart area
- Configure chart area's font
- Configure chart area format
- Chart gallery
- Area chart
- 100% Stacked chart
- Stacked Area chart
- Clustered Bar chart
- 100% Stacked Bar chart
- Stacked Bar chart
- Bubble chart
- Clustered Column chart
- 100% Stacked Column chart
- Stacked Column chart
- Combination chart
- Combination chart
- Line chart
- 100% Stacked line with markers chart
- Stack line with markers chart
- Line Markers chart
- 100% Stacked Line chart
- Stacked Line chart
- Pie chart
- Doughnut chart
- High-Low-Close stock chart
- Open-High-Low-Close stock chart
- Volume-High-Low-Close stock chart
- Volume-Open-High-Low-Close chart
- Scatter chart
- Scatter with straight lines and markers
- Scatter with smooth Lines
- Scatter with smooth lines and markers
- Chart lines
- Create connector line for pie of pie chart
- Create drop line
- Create high-low line
- Create series line for column chart
- Create trend line
- Create up down bars for line chart
- Chart title
- Configure chart title with rich text
- Configure chart title style
- Data label
- Configure data label's format
- Configure data label's text
- Data point
- Configure data point's format
- Configure negative point style
- Configure secondary section for pie of pie chart
- Legend
- Configure legend entry font style
- Configure legend format
- Configure legend position and layout
- Markers
- Configure markers style
- Configure markers format
- Excel 2016 New Charts
- Add a box&whisker chart
- Add a funnel chart
- Add a histogram chart
- Add a pareto chart
- Add a sunburst chart
- Add a treemap chart
- Add a waterfall chart
- Plot area
- Plot only visible cells
- Configure plot area format
- Series
- Add series for chart
- Change series type
- Configure bubble chart's layout
- Configure series format
- Create secondary axis
- Delete series
- Add new points for existing series
- Set column chart colors to vary
- Add user shapes
- Copy chart
- Cut chart
- Duplicate chart
- Create chart
- Delete chart
- Set angle of tick mark labels
- Set angle of chart title
- Error Bars
- Custom Type
- Delete error bar
- Set includes type and end cap type
- Style
- Fixed value type
- Percentage type
- Standard error type
- Standard deviation type
- X and Y direction
- Chart with custom name
- Shape
- Add shape with custom name
- Set gradient path type
- Set alignment of shape's text
- Shape
- Adjustment points
- Set shape's 3D format
- Set shape's line format
- Set shape's gradient fill
- Set shape's pattern fill
- Set shape's picture fill
- Set shape's solid fill
- Set shape's texture fill
- Connect shapes with connector shape
- Set shape's text
- Copy shape
- Cut shape
- Duplicate shape
- Group shapes
- Ungroup shape
- Picture
- Create picture
- Delete picture
- Copy picture
- Cut picture
- Duplicate picture
- Slicer
- Add a custom slicer style
- Add slicers to pivot tables
- Add slicers to tables
- Apply built-in style to slicer
- Configure slicer layout
- Auto-filter table with slicer
- Copy slicer
- Cut slicer
- Duplicate slicer
- Use slicer to filter table
- Use a slicer to clear a filter
- Workbook
- Configure workbook view
- Create new workbook
- Import csv file to workbook
- Import csv file to workbook with options
- Only import data from Excel
- Import Excel file
- Import Excel file with password
- Do not recalculate after opening Excel
- Import and export OLE objects
- Open and save xlsm file
- Load and save json containing shapes
- Protect workbook
- Save workbook to csv file
- Save workbook to csv file with options
- Save to Excel file
- Save to Excel file with password
- ToJson and FromJson
- Unprotect workbook
- Protect Workbook
- Unprotect Workbook
- Worksheets
- Access a worksheet
- Activate a worksheet
- Add a chart sheet
- Add a worksheet
- Autofit column width and row height
- Configure worksheet properties
- Configure worksheet view
- Control adjustment of page breaks
- Copy worksheet
- Copy worksheet between workbooks
- Delete a worksheet
- Move worksheet
- Move worksheet between workbooks
- Protect worksheet
- Set background image for worksheet
- Tag of sheet/row/column/cell
- Unprotect worksheet
- Protect worksheet with password
- Worksheet To and from JSON
- Unprotect worksheet with password
- Showcase
- Basic sales report
- Bid tracker
- Blood pressure tracker
- Blood sugar tracker
- Cost analysis with Pareto chart
- Customer profitability analysis
- Event budget
- Financial KPIs
- Income statement
- Monthly business budget
- Movie list
- Personal address book
- Personal net worth calculator
- Simple invoice
- To do list with progress tracker
- Templates
- Data source
- Custom object
- Json file
- ResultSet
- Variable
- Properties
- Set context
- Set expansion type
- Set group type
- Set pagebreak
- Set range
- Set sort type
- Style
- Cell style
- Merge cell
- Template cell
- Data template
- Expression template
- Function template
- Inline template
- Sheet template
- Global options
- Insert mode
- Keep row & column size
- Formula template
- Image template
- Chart
- Conditional formatting
- Employee absence schedule
- Sales tracker
What's New
- New Templates Features to Generate Reports - Templates support with comprehensive syntax and API to bind Excel documents with data and generate Excel reports with advanced layouts.
- Insert images from a database in Excel reports.
- Support conditional formatting when generating reports. All types of conditional formatting rules are supported.
- Specify default behavior of the Excel template, when it expands, for example - specify default row height/column width, insert extra spaces in the final report.
- Support templates in a chart - define series data.
- Export Excel formula and expressions. Formulas applied on a template can now be exported as-is to Excel file.
- Convert Excel Objects Directly to Image Formats - Use the ToImage method of IWorksheet, IRange, and IShape. This feature will help saving shape, worksheet, range, images used in your Excel files directly to image format without extra step or additional API.
- Support Password-Protected Workbooks and Worksheets - Enable protecting a workbook/worksheet using a password.
Resources
Contact
Forums (24-hour Global Support)
Submit a Ticket