High-speed Excel spreadsheet API 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
- Require no Excel dependencies
- Deploy to Azure and AWS
-
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
Analyze, 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 Sheets
Import existing templates effectively in Documents for Excel and attach it to Spread.Sheets for an interactive calendar. Includes merged cells, references, color-coding, and date calculations
Try the CalendarGenerate 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, and more in your spreadsheet apps
Get the movie list
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, 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 tables of data, and add pivot tables to automatically count, total, or average the data
Explore the advanced features of this spreadsheet API
Click through to view the code, generate the spreadsheet, and download the Excel file
- Platforms supported
- Java 6.0 or higher
- Full support on Windows, Linux, and Mac
- Workbooks
- Configure workbook view
- Convert workbook to JSON and from JSON
- Create new workbook
- Do not recalculate after opening Excel
- Import csv file to workbook
- Import csv file to workbook with options
- Import Excel file
- Import Excel file with password
- Import Excel files with macros (NEW)
- Only import data from Excel
- Save to Excel file
- Save to Excel file with password
- Save workbook to csv file
- Save workbook to csv file with options
- Base workbook style on existing style (NEW)
- Worksheets
- Access a worksheet
- Activate a worksheet
- Add a worksheet
- Background image (NEW)
- Configure worksheet properties
- Configure worksheet view
- Delete a worksheet
- Protect worksheet
- Save worksheet to csv file
- Save worksheet to csv file with options
- Unprotect worksheet
- Conditional Formatting
- Average
- Cell Value
- Color Scale
- Data Bar
- Expression
- Icon Sets
- Top Bottom
- Unique
- Charts
- 20+ chart types with variations, including area, column, line, bar, bubble, HLOC, scatter, pie, and more
- 3D charts
- Access and customize a group of series
- Access and customize each data series
- Access and customize value axes, category axes, and series axes
- Add charts to a worksheet
- Add data series to a chart
- Add, remove, or customize each data label in a series
- Configure the chart area
- Configure axis titles, legends, and tick marks
- Chart lines, including trendline, dropline, high-low line, and series line
- Customize chart titles
- Customize each data point in a data series
- Customize chart legends
- Customize data labels
- Configure data points
- Customize markers
- Edit chart title
- Format your content
- Alignment (horizontal, vertical, ReadingOrder, ShrinkToFit, orientation, wrap text)
- Borders (Dashed, dashdot, dotted, double, medium, hair, and more)
- Create custom styles
- Fill Colors (Solid, pattern, linear gradient, rectangular gradient)
- Fonts (Color, size, name, bold, italic, underline, strikethrough, superscript, subscript)
- Number formats
- Protection
- Range styles
- Rich text in cells (NEW)
- Security settings
- Formulas
- Array formulas
- Custom functions
- Dirty and calculate methods
- Hundreds of built-in Excel functions
- Table formulas
- Grouping
- Clear outline
- Collapse group
- Create range group
- Group data
- Show specific level group
- Ungroup range
- Hyperlinks
- Create hyperlinks
- Delete hyperlinks
- PDF Export
- Borders
- Conditional formatting
- Export fills
- Font effects
- Number formats
- Export overflow text
- Export picture
- Vertical text (NEW)
- Save workbook to PDF
- Save worksheet to PDF
- Set font's folder
- Set page setup
- Sparklines
- Export tables
- Pivot Tables
- Create pivot tables
- Filter items in pivot tables
- Modify pivot field subtotal type
- Refresh pivot table
- Set field's summarize function
- Range Operations
- Access cells, rows, and columns
- Access each area of a range
- Access ranges in various ways
- Cut, copy, and paste a range
- Get a row count or column count
- Get used range
- Get used range features
- Hide a row or column
- Insert or delete cells
- Insert or delete rows and columns
- Merge cells
- Set row height and column width
- Set values to a range
- Use CellInfo Helper class
- Shapes and Pictures
- Create, cut, copy, delete, and duplicate pictures
- Add shapes, add text to, connect, fill, cut, copy, and duplicate shapes
- Fill shapes, add text to them, and set the line
- Insert arrows, lines, charts, slicers, pictures, and general
- Load and save SpreadJS JSON files with shapes (NEW)
- Slicers
- Add a custom slicer style
- Add slicers to pivot tables
- Add slicers to tables
- Apply built-in style to slicer
- Auto-filter table with slicer
- Configure slicer layout
- Copy slicer
- Cut slicer
- Duplicate slicer
- Use a slicer to clear a filter
- Use slicer to filter table
- Sparklines
- Create sparklines
- Clear sparkline and sparkline group
- Configure sparklines
- Group existing sparklines
- Use date axis
- Spread.Sheets Integration
- Load From JSON on client-side to view the result of the Excel file on server
- Load and save SpreadJS JSON files with shapes (NEW)
- Export the whole workbook to a JSON string, then transfer the JSON string to client side
- Open an Excel file with GcExcel existing on serverÂ
- Tables
- Apply sorting to a table column
- Access each range of a table
- Add or remove a table column
- Add or remove a table in a worksheet
- Apply built-in or custom table styles
- Apply filtering to a table column
- Perform calculations for a specific table range
- Validate your data
- Apply data validations like whole number, decimal, list, date, time, text length
- Apply custom validations
- Excel Reporting
- Aging report
- Address book report
- Annual financial report
- Basic sales report
- Bid tracker report
- Blood pressure tracker
- Cost analysis report
- Customer profitability analysis
- Family budget
- Home inventory
- Net worth calculator
- Progress tracker
- Personal budget
- Project cost tracker
- Student calendar
- Travel expense report
Try the Document API Demos
Documents for Excel Demo
GcExcel Java Spring Boot Demo
What's New
Add background images to spreadsheets
Add rich text to spreadsheet cells.
Load, save and preserve Excel files containing macros (I/O .xslm).
Add a background image to worksheet.
Support workbook styles and create new styles from existing styles.
Export Excel files containing vertical text to PDF.
Load and save SpreadJS JSON files with shapes.
Set JDK 8 date time types to cell value.
What's New Roadmap