SpreadsheetInfo Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Contains static licensing methods and diagnostic information about executing GemBox.Spreadsheet assembly.

public static class SpreadsheetInfo
Public Module SpreadsheetInfo
Inheritance:
System.Object
SpreadsheetInfo

Properties

FullVersion

GemBox.Spreadsheet assembly full version.

public static string FullVersion { get; }
Public Shared ReadOnly Property FullVersion As String
Property Value
System.String

Title

GemBox.Spreadsheet assembly title.

public static string Title { get; }
Public Shared ReadOnly Property Title As String
Property Value
System.String

Methods

SetLicense(String)

Call this method from your application to set GemBox.Spreadsheet serial key.

public static void SetLicense(string serialKey)
Public Shared Sub SetLicense(serialKey As String)
Parameters
serialKey
System.String

Serial key.

Remarks

You should call this method before using any other class from GemBox.Spreadsheet library. Key can only be set once (if you try second key, it will be ignored). The best place to call this method is from static constructor of your application's main class.

Valid serial key has multiple groups of alphanumeric characters, separated with dashes.

Free version serial key is: FREE-LIMITED-KEY.

Events

FreeLimitReached

Occurs in loading or saving ExcelFile when GemBox.Spreadsheet assembly is used with FREE-LIMITED-KEY license key and free limit is reached.

public static event EventHandler<FreeLimitEventArgs> FreeLimitReached
Public Shared Event FreeLimitReached As EventHandler(Of FreeLimitEventArgs)
Event Type
System.EventHandler<FreeLimitEventArgs>
Remarks

This event is raised when GemBox.Spreadsheet assembly is used with FREE-LIMITED-KEY license key and maximum number of rows (150 rows) or sheets (5 sheets) are reached.

Free mode will read / write first 150 rows/5 sheets normally and, if file has more than 150 rows or 5 sheets, it will throw FreeLimitReachedException.

You can use this event to continue using the assembly in a trial mode for performance testing (set FreeLimitReachedAction to ContinueAsTrial) or to stop further reading/writing (set FreeLimitReachedAction to Stop).

Trial mode will read and write all file content but will insert word "TRIAL" on random places in the file.

For more information about GemBox.Spreadsheet evaluation and licensing, see evaluation and licensing.