Free and Professional Excel library in Java

GemBox.Spreadsheet for Java is a Java library for processing Excel files that has four working modes:

Every working mode uses the same GemBox.Spreadsheet.jar file and delivers the same performance and set of features, but has some restrictions (except for the Professional mode).

Before using any other member from GemBox.Spreadsheet for Java library, you must call a SpreadsheetInfo.setLicense method to set the working mode.

Free Excel library

The default behavior of the Free mode is that a FreeLimitReachedException is thrown when loading or saving an Excel file with more than 150 rows or 5 sheets.

You can change this behavior to achieve the trimming of spreadsheet content to the first 150 rows and 5 sheets if you handle a FreeLimitReached event by adding a listener using SpreadsheetInfo.addFreeLimitReachedListener and setting FreeLimitEventArgs.setFreeLimitReachedAction to FreeLimitReachedAction.STOP.

You can use the Free mode for any purpose, including use in commercial applications.

// Set license key to use GemBox.Spreadsheet for Java in a Free mode.
SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

// Stop reading/writing a spreadsheet when the free limit is reached.
SpreadsheetInfo.addFreeLimitReachedListener(eventArguments -> eventArguments.setFreeLimitReachedAction(FreeLimitReachedAction.STOP));

Trial Excel library

You can use the Trial mode to evaluate beyond the first 150 rows and 5 sheets. Both Free and Trial modes use the same FREE-LIMITED-KEY key and can be used for an unlimited time period.

To set the Trial mode, you need to handle a FreeLimitReached event by adding a listener using SpreadsheetInfo.addFreeLimitReachedListener and setting FreeLimitEventArgs.setFreeLimitReachedAction to FreeLimitReachedAction.CONTINUE_AS_TRIAL.

The limitation of Trial mode is when loading or saving an Excel file approximately 5% of randomly selected cells will have their value replaced with TRIAL.

// Set license key to use GemBox.Spreadsheet for Java in a Free mode.
SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

// Continue to use the component in a Trial mode when free limit is reached.
SpreadsheetInfo.addFreeLimitReachedListener(eventArguments -> eventArguments.setFreeLimitReachedAction(FreeLimitReachedAction.CONTINUE_AS_TRIAL));

Time Limited Excel library

You can also use the Time Limited mode to evaluate beyond the first 150 rows and 5 sheets.

To set the Time Limited mode, you need to use a temporary or time-limited key, which you can get by contacting us.

The limitation of Time Limited mode is that it can be used only for 30 days.

// Set license key to use GemBox.Spreadsheet for Java in a Time Limited mode.
SpreadsheetInfo.setLicense("XX−<START DATE>−<END DATE>-XXXXXXXXXX");

Professional Excel library

To set the Professional mode, you need to use a professional key which you can get by purchasing a license.

The Professional mode has no limitations, and the professional keys are perpetual (can be used forever).

// Set license key to use GemBox.Spreadsheet for Java in a Professional mode.
SpreadsheetInfo.setLicense("XXXXXXXXXX");

Want more?

GitHub

Check the next example or select an example from the menu. You can also download our examples from the GitHub.


Like it?

Download Buy

If you want to try the GemBox.Spreadsheet for Java yourself, you can download the free version. It delivers the same performance and set of features as the professional version, but with some operations limited. To remove the limitation, you need to purchase a license.