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 very 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 has included support for 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.

Previous Next

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 very 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 has included support for 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.