Java Library for Processing Spreadsheet Documents
Free Java API that enables software programmers to create and modify Microsoft Excel files using Java code.
GcExcel-Java is an open source high-speed Java Excel spreadsheet processing API that enables software programmers to create and modify Excel files using Java commands. The feature-rich API is easy to use and can be smoothly used on popular operating systems like Windows, MAC, and Linux. The library supports range operations on cells, rows, or columns in Excel documents with ease.
You can easily create your own custom functions and use them. The library also fully supports PDF generation from Excel templates supporting features like sparklines and tables. You can also easily export the workbook/worksheet/range to HTML. The great thing is that you can easily import and export Excel template files on the server-side.
The GcExcel-Java library supports several important features related to Spreadsheet creation and management, such as read existing Excel files, import spreadsheets, filtering support, calculate data, query, convert spreadsheet to PDF, add sorting, conditional formatting, and data validation, insert charts, adding shapes or pictures, adding comments, inserting hyperlinks, themes and much more.
At A Glance
An overview of GcExcel-Java features.
- Create spreadsheets
- Modify spreadsheet
- Read spreadsheet
- Grouping support
- Filtering support
- Add comments
- Add hyperlinks
- Add shape
- Add images
- Add sheet
- XLSX Spreadsheet
- Slicer support
GcExcel-Java only requires Java runtime.
Getting Started with GcExcel-Java
The recommended way to install GcExcel-Java into your project is by using GitHub. Please use the following command for smooth installation
Install GcExcel-Java via GitHub
$ git clone https://github.com/GrapeCity/GcExcel-Java.git
Convert Excel file to PDF
The open source GcExcel-Java library lets software developers convert an Excel file to PDF documents inside their own apps. The library has provided several important features for exporting Excel files such as save Worksheet to PDF, export the outline column of the worksheet to PDF file, Excel borders to PDF, export spreadsheet with tables to PDF, and many more.
Create a New Workbook via Java
The GcExcel-Java library allows software programmers to create a new workbook from scratch with just a couple of lines of Java code inside their apps. It provides all the necessary properties and methods required to create a workbook. After the creation of the spreadsheet, you can easily modify it and can perform complex operations on the data residing in the spreadsheets with ease.
Create and PivotTable in Spreadsheets
The free library GcExcel-Java has provided functionality for creating and managing Pivot Table using Java commands. Pivot Table is useful for data summarization and can be used to automatically count, calculate the total or average of the data stored in a spreadsheet. The library has provided support for several important features such as display grand total, modify pivot fields, set conditional format, sort, count, set number or text format, and many more.
Add & Modify Charts to Excel Workbook
The GcExcel-Java supports adding and modifying charts inside an Excel Workbook using Java commands. It has provided several functions and methods related to chart management and creation, such as adding data series, customize chart titles and legends, access and customize a group series, add or remove data label, customization of value axes, and category axes with ease.