Evaluation and Licensing
GemBox.Spreadsheet works in four different modes:
Free mode - free of charge, limited to 5 worksheets and 150 rows per worksheet.
Trial mode - free of charge, randomly selected cells will have their value replaced with string TRIAL.
Time Limited mode - free of charge, limited to 30 days.
Professional mode - requires purchasing a license key, no limitations.
All modes use the same GemBox.Spreadsheet jar so there is no need to switch the component when switching modes.
The first thing to do when coding with GemBox.Spreadsheet is to instruct the component in which mode it will be used. This is accomplished by calling SpreadsheetInfo.setLicense(String) method with the specific license key parameter:
FREE-LIMITED-KEY, to use the component in Free mode.
The temporary license key that you receive after sending us a request for Time Limited mode.
The professional license key that you receive after purchasing GemBox.Spreadsheet, to use the component in Professional mode.
SpreadsheetInfo.setLicense method must be called before using any other class from GemBox.Spreadsheet component.
SpreadsheetInfo.setLicense method can be called multiple times. What is important is that it is called with the same license key.
Ideally, it should be called at the startup of your application. For example, it can be called in a main method.
Free mode delivers the same performance and set of features as Professional mode, with the following limitations:
FreeLimitReachedException will be thrown when loading or saving a spreadsheet, if it has more than 5 worksheets and any of them has more than 150 rows.
Spreadsheet content will be trimmed to first 5 worksheets and 150 rows per worksheet when loading or saving a spreadsheet, if you handle FreeLimitReached event by adding listener using SpreadsheetInfo.addFreeLimitReachedListener(FreeLimitReachedListener) and set the FreeLimitEventArgs.setFreeLimitReachedAction to FreeLimitReachedAction.STOP.
If you want to evaluate GemBox.Spreadsheet performance beyond the first 5 worksheets and 150 rows, then use FreeLimitReachedListener which sets the FreeLimitEventArgs.setFreeLimitReachedAction to FreeLimitReachedAction.CONTINUE_AS_TRIAL, as in this following code snippet:
// Set license key to use GemBox.Spreadsheet 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)); // Here goes your application specific code.
This option will enable you to read / write entire spreadsheet content, with the following limitation imposed on all cells after the first 5 worksheets or 150 rows per worksheet, whichever comes first:
When loading / saving a spreadsheet - approximately 5% of (randomly selected) cells will have their value replaced with string TRIAL.
If you have evaluated the component and are satisfied with it, you can purchase the license key to use the component in the Professional mode - without any limitations.
After purchase, the only thing you need to do is to replace FREE-LIMITED-KEY with your purchased license key in SpreadsheetInfo.setLicense(String) method call.
There is no other jar for the Professional mode. You should continue to use the reference to existing GemBox.Spreadsheet jar in your project when switching to Professional mode.
Professional mode also includes technical support with prompt bug fixes. For more information, see Technical Support.