In This Topic
With a set of class libraries, collections, interfaces, methods and fields that comes packaged with GcExcel Java; developers can build everything right from scratch while working with spreadsheets for increased productivity and improved data analysis.
GcExcel Java assists developers in creating powerful spreadsheets while working with Java desktop and web applications with the following key features:
- Lightweight API Architecture for Enhanced Efficiency
GcExcel Java possesses an extermely lightweight API architecture that allows users to save significant amount of time, storage space and development efforts while also maximizing the overall efficiency of generating, loading, editing, exporting and converting spreadsheets.
- Flexible Themes and Components
Using GcExcel Java, users can apply custom themes, configure components, summarise data, set custom styles, embed drawing objects, apply cell formatting and integrate a robust calculation engine while working with spreadsheets.
- Seamless Excel Compatibility
GcExcel Java is fully compatible with MS Excel. With this product, users can insert pivot tables, include comments, add charts, shapes, pictures, slicers, sparklines and tables, apply conditional formatting, data validation, filters and formulas, etc.
- Extensive Support for Major Operating Systems
You can deploy the Java desktop and web applications created using GcExcel Java on all major operating systems including Microsoft Windows, Linux and macOS.
- Based on Excel Object Model
With the interface-based Java API model, you can import data, calculate formulas, query, generate, and save worksheets with complex scenarios as per custom preferences.
- No Dependency on MS Excel
In order to work with GcExcel Java, users don't need to install MS Office Suite and access MS Excel on their systems.
- Use Built-in Templates for Simple Forms
With the help of built-in templates, you can quickly create simple forms like invoice etc. while working with spreadsheets.
- Create Interactive Experience with SpreadJS Sheets
GcExcel Java provides a completely interactive and user-friendly spreadsheet experience when used concurrently with Spread.Sheets.
- Workbook and Worksheets
You can create workbook and add worksheets while also performing the import and export operations. Further, you can activate worksheets, configure its display, delete it and protect it from modification or encrypt it with a password.
- Formulas and Functions
With extensive support for implementing formulas, adding custom functions and choosing from 450+ built-in functions, users can execute complex spreadsheet calculations without any hassle.
- Pivot and Excel Tables
You can create tables and pivot tables to automatically calculate the count, total or average of data in the spreadsheets. You can also rename pivot table fields, manage grand total visibility settings and change row Axis layout of pivot field.
- Export to PDF
Using the export to PDF feature, users can save spreadsheets to PDF files with different page settings, features, background image, document properties and security options. You can also export Excel sheets with charts, slicers and sheet background images.
- Deploy Apps with Excel Spreadsheets to the Cloud
With GcExcel, you can apply cloud based deployments and deploy your applications on Azure, AWS Lambda and Google Cloud Java.
- Shapes and Pictures
With GcExcel API, you can insert and customize shapes and pictures on cells of a worksheet, apply formatting, configure text, insert hyperlinks, set adjustment points of the shapes and group/ungroup them in a worksheet.
- Use Templates to create custom Excel reports
GcExcel provides templates with comprehensive API to create custom Excel reports with advanced layouts. You can use multiple data soures to bind the data. The templates provide flexible syntax, easy notations and extended reusability making it an ideal solution to generate Excel reports.
For more information on the complete list of supported features in GcExcel, refer to the Features topic in the documentation.