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

[Joe Magano]

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:

• Unified programming interface for multiple file formats (XLSX, XLS, ODS, CSV, HTML, PDF and XPS). More ?
• Rich Set of Features. More ?
• No dependency on Microsoft Word.
• Many times faster than Microsoft .NET Excel automation. More ?
• Plain and fair licensing. More ?
• 100% managed code (C#), follows .NET class library design guidelines.
• Simple and easy-to-use programming interface. More ?
• Preserves unsupported file format features. More ?
• For more details go to GemBox.Spreadsheet features page or use GemBox.Spreadsheet Sample Explorer.

GemBox.Spreadsheet common uses:

• Read & write Excel and HTML files in C# / VB.NET.
• Create Excel and HTML files in C# / VB.NET.
• Convert between Excel and HTML formats in C# / VB.NET.
• Convert Excel file to PDF in C# / VB.NET.
• Print Excel file in C# / VB.NET.
• Export to Excel / PDF from ASP.NET.
• Import & export DataSet to Excel in C# / VB.NET.
• Import & export DataTable to Excel in C# / VB.NET.
• Import & export DataGridView to Excel in C# / VB.NET.

[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#

<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

<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.