High-speed Excel spreadsheet API Library for Java
Command total control of your spreadsheets—with no dependencies on Excel
- Generate, load, edit, and save spreadsheets
- Parse, convert, and share spreadsheets
- Calculate formulas and format cells
- Embed charts, images, and graphics in Excel docs
- Convert Excel spreadsheets to PDF and image files
- Require no Excel dependencies
- Deploy to Azure and AWS
- Create Custom Reports using
Excel (.xlsx) templates
-
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 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 steps to begin using Documents for Excel to code spreadsheets. The Features section offers sample code for each feature, while the Spread.Sheets Viewer, Excel Reporting, and Excel Templates sections offer sample code for real-life scenarios.
- 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
- 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
- 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 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
- 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
- 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
- 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
- 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
- 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
What's New
Print Specific Pages of Excel File to a PDF
- Templates support to generate Excel reports
- New Excel 2016 chart types
- Support Excel chart and splicer spreadsheets conversion to PDF
- Add Chart Sheet
- Outline Subtotal
- Support security options when saving to PDF
- Support document properties when saving to PDF
- Support sheet background image to PDF
- Protect workbook
- Add even more shape features, pivot table grand totals, and report layout options
- Two new APIs | precedents and dependents
- Shape adjustment
- Export multiple image Excel files to PDF (reduced file size)
- License worksheets (instances)
- Rename pivot and data fields
Resources
Contact
Forums (24-hour Global Support)
Submit a ticket