C# / VB.NET Excel component - GemBox.Spreadsheet 3.7

Joe Magano

New member
Joined
May 28, 2013
Messages
2
Programming Experience
3-5
GemBox.Spreadsheet is a C# / VB.NET Excel component for easy and efficient Excel file processing in .NET without Microsoft Excel.
GemBox.Spreadsheet 3.7 supports reading XLSX, XLS, ODS and CSV formats and writing, creating and converting to XLSX, XLS, ODS, CSV, HTML, PDF, XPS and image formats.

GemBox.Spreadsheet has following advantages:



GemBox.Spreadsheet common uses:


[h=2]Free mode[/h]You can download GemBox.Spreadsheet Free setup and evaluate GemBox.Document free of charge and for an unlimited time period. Free version is limited to 150 rows per sheet and 5 sheets per workbook.
[h=2]Trial mode[/h]To evaluate beyond the first 5 worksheets and 150 rows, handle SpreadsheetInfo.FreeLimitReached event and set the FreeLimitEventArgs.FreeLimitReachedAction to FreeLimitReachedAction.ContinueAsTrial, as in this following code snippet:
C#
C#:
<code>// Set license key to use GemBox.Document in a Free mode.</code> 
<code>SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");</code> 

<code>// Continue to use the component in a Trial mode when free limit is reached.</code> 
<code>SpreadsheetInfo.FreeLimitReached +=</code> 
<code>(sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial;</code> 

<code>// Here goes your application specific code.</code>

VB.NET
C#:
<code>' Set license key to use GemBox.Document in a Free mode.</code>
<code>ComponentInfo.SetLicense("FREE-LIMITED-KEY")</code>

<code>' Continue to use the component in a Trial mode when free limit is reached.</code>
<code>AddHandler ComponentInfo.FreeLimitReached,</code>
<code>Sub(sender, e) e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial</code>

<code>' Note: Single-line Sub Lambdas are supported from Visual Basic 10 compiler.</code>
<code>' See: http://msdn.microsoft.com/en-us/library/ff637436.aspx#code-snippet-5</code>
<code>' If you are using Visual Basic 9 or older Visual Basic compiler,</code>
<code>' then you must extract event handler to a method and assign it as an event handler.</code>

<code>' Here goes your application specific code.</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.
For more information, see GemBox.Spreadsheet Evaluation help page.
[h=2]Professional mode[/h]If you want to use the component in a professional mode ? without any limitations ? you need to purchase the license key. For more information about evaluation and licensing, see here.

We hope GemBox.Spreadsheet will improve developer's productivity and functionality & efficiency of spreadsheet processing / reporting applications.
 
Back
Top Bottom