GrapeCity introduces Documents for Excel (GcExcel) Java Edition, a high-speed, feature-rich Excel document API based on VSTO that can help developers work with spreadsheets in Java applications. The library helps to generate, convert to pdf, calculate, format, and parse spreadsheets in any application. You can work with a variety of features like importing spreadsheets, calculate data, query, generate, and export any spreadsheet, add sorting, filtering, formatting, conditional formatting and data validation, grouping, sparklines, charts, shapes, pictures, slicers, comments, hyperlinks, themes etc. In addition, you can import existing Excel templates, add data and save the spreadsheets back. You can also use GcExcel together with Spread.Sheets, another GrapeCity Spread product that is included in GrapeCity SpreadJS. GcExcel can also import and export Excel template files on the server side. Spread.Sheets works in the browser (client side) as a viewer or editor.
With GcExcel, you can also load, edit, analyse, convert and save spreadsheets in Java applications with full support on Windows, MAC and Linux.
This repository contains source project of Examples and Showcases of GcExcel to help you learn and write your own applications.
| Directory | Description |
|---|---|
| gcexcel-1.5.3-SNAPSHOT | Contains GcExcel Java CTP jar package and its dependency packages |
| gcexcel-1.6.0-SNAPSHOT | Contains GcExcel Java CTP jar package and its dependency packages |
| gcexcel-2.0.0 | Contains GcExcel Java 2.0.0 jar package and its dependency packages |
| gcexcel-2.0.1 | Contains GcExcel Java 2.0.1 jar package and its dependency packages |
| Examples.Library | A collection of Java examples that help you learn and explore the API features |
| SpringBootDemo/SpringBoot+React | A source project that demonstrates how to use GcExcel Java with SpringBoot + React + Spread.Sheets |
| SpringBootDemo/SpringBoot+Angular2 | A source project that demonstrates how to use GcExcel with SpringBoot + Angular2 + Spread.Sheets |
- Improved the performance of Workbook.fromJson method, when json file contains lot of styles.
- PDFBox now can be installed automatically for all versions of eclipse maven plugin.
- Exception thrown when Workbook opens the stream returned by HttpServletRequest.getInputStream().
- Null pointer exception is thrown on saving to PDF, if the font used is null.
- GcExcel throws exception on loading ssjson file with null values.
- Merged range in table couldn't be rendered to pdf.
- The hidden rows are still rendered to pdf after loading ssjson file.
- Demo Site: http://demos.componentone.com/gcdocs/gcexceljava/
- Maven Repo Address: https://search.maven.org/artifact/com.grapecity.documents/gcexcel/2.0.0/jar/