Install via NuGet

ReoGrid V4 is installed from UNVELL’s package feed; the packages are not on nuget.org.

1. Create an access token under Access Tokens in the customer portal.
2. Register the feed once, with your portal email address as the user name and the token as the password:

dotnet nuget add source "https://packages.unvell.com/nuget/v3/index.json" --name reogrid --username "[email protected]" --password "<access token>" --store-password-in-clear-text

3. Install the package for your platform:

dotnet add package unvell.ReoGrid4

The portal page shows the feed command with your address and token filled in. The assemblies can also be downloaded from the customer portal and referenced directly.

Note: The unvell.ReoGrid.dll and unvell.ReoGridWPF.dll packages on nuget.org are ReoGrid V3, the open-source edition (MIT license). See Download.

Set the license key

Since v4.5, ReoGrid requires a license key. Call ReoGridLicense.SetLicense once at application startup, before the grid is used:

using unvell.ReoGrid.License;

ReoGridLicense.SetLicense("(the license key from your customer portal)");

Without a valid key, a gray overlay covers the grid and mouse and keyboard input, cell editing and printing are blocked, and PDF export throws InvalidOperationException. License keys are available from the customer portal.

Development-device activation (v4.6 and later)

Starting with v4.6, each newly issued Professional license key is assigned to one development device. License keys you already have — every key issued before device activation, and every Enterprise key — keep working as-is and are not checked online.

For a key that is assigned to a device, the check runs in two places only: at build time (an MSBuild task included in the NuGet package), and when SetLicense is called while a debugger is attached. The applications you build and distribute are not part of this check — they run on your users’ machines exactly as before.

Install Visual Studio Toolbox Shortcut for Windows Forms

To add a shortcut to the Visual Studio toolbox, perform the following steps:

1. Right-click on the Toolbox panel and click ‘Choose Items…’
2. Choose the ’.NET Framework Components’ tab
3. Click the ‘Browse…’ button
4. Choose ‘unvell.ReoGrid.dll’ in the open file dialog
5. Click the OK button to close the dialog
6. Click on the ReoGridControl item that appears at the bottom of the toolbar to select it:

Select a range on the form designer; when the mouse is released, the ReoGrid spreadsheet component will be added as shown below:

Add Control by Code for Windows Forms

ReoGrid provides different feature-set editions, and each edition has different reference requirements. Add references according to the edition used in your application.

• Minimum Edition - Minimum feature set (no formula calculation supported)
• Standard Release Edition - Standard features (Recommended)
• Extension Edition - Extended features, including script language execution integration (like VBA)

If you are unsure which edition to use, the Standard Release Edition with a single DLL (unvell.ReoGrid.dll) is recommended.

Add Windows Forms Control in C#

1. Import namespaces:

using unvell.ReoGrid;

2. Create a ReoGrid instance and add it to any Windows Forms container, such as a Form or Panel.

var grid = new unvell.ReoGrid.ReoGridControl()
{
  Dock = DockStyle.Fill,
};

this.Controls.Add(grid);  // add to form or panel

Learn more about workbook and worksheet.

Add Windows Forms Control in VB.NET

1. Import namespaces:

Imports unvell.ReoGrid

2. Create a ReoGrid instance and add it to any Windows Forms container, such as a Form or Panel.

Dim grid As New MyReoGridControl() With {.Dock = DockStyle.Fill}
Me.Controls.Add(grid)

Add Control in XAML for WPF Applications

Add the ReoGrid DLL reference to the target project and edit the XAML file of the main window as shown below:

File MainWindow.xaml:

<Window
  xmlns="/schemas.microsoft.com/winfx/2006/xaml/presentation"
  xmlns:x="/schemas.microsoft.com/winfx/2006/xaml"
  **xmlns:rg="clr-namespace:unvell.ReoGrid;assembly=unvell.ReoGrid"**
  x:Class="WPFDemo.MainWindow" Title="MainWindow" Height="640" Width="800">
  <Grid>

    <rg:ReoGridControl x:Name="grid" ></rg:ReoGridControl>

  </Grid>
</Window>

Example: WPF Design Time