Free and Professional Excel library in C# and VB.NET

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

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

Before using any other member of GemBox.Spreadsheet library from your C# or VB.NET application, 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 by handling a SpreadsheetInfo.FreeLimitReached event and setting FreeLimitEventArgs.FreeLimitReachedAction to Stop.

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

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

// Stop reading/writing a spreadsheet when the free limit is reached.
SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.Stop;
' Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

' Stop reading/writing a spreadsheet when the free limit is reached.
AddHandler SpreadsheetInfo.FreeLimitReached, Sub(sender, e) e.FreeLimitReachedAction = 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 SpreadsheetInfo.FreeLimitReached event and set FreeLimitEventArgs.FreeLimitReachedAction to ContinueAsTrial.

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 in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

// Continue to use the component in a Trial mode when free limit is reached.
SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial;
' 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.
AddHandler SpreadsheetInfo.FreeLimitReached, Sub(sender, e) e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial

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 in a Time Limited mode.
SpreadsheetInfo.SetLicense("XX−<START DATE>−<END DATE>-XXXXXXXXXX");
' Set license key to use GemBox.Spreadsheet 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 in a Professional mode.
SpreadsheetInfo.SetLicense("XXXXXXXXXX");
' Set license key to use GemBox.Spreadsheet 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 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.