Install via NuGet

ReoGrid for Windows Form

To install ReoGrid Windows Form standard edition, use the NuGet command:

PM> Install-Package unvell.ReoGrid.dll

ReoGrid for WPF

PM> Install-Package unvell.ReoGridWPF.dll

Install Visual Studio Toolbox Shortcut for Windows Forms

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

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

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

Add Control by Programming for Windows Forms

ReoGrid provides different features set editions, and each edition has different reference requirements. Add the references according to edition used in 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 not sure which edition to use, Standard Release Edition with single DLL (unvell.ReoGrid.dll) is recommended.

Add Windows Form Control in C#

1. Import namespaces:

using unvell.ReoGrid;

2. Create ReoGrid instance and add it into any windows form container, such as Form or Panel.

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

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

Imports unvell.ReoGrid

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

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

To install ReoGrid into .NET applications, see installation.

Component Overview

Usually used objects:

• Workbook
• Worksheet
• Cell
• Row header & Column header
• Range
• Style
• Actions

Workbook and Worksheet

The control itself is also workbook, a control (workbook) contains multiple worksheets.

Call control (workbook) APIs:

var grid = this.reoGridControl;
grid.fun();

Call worksheet APIs:

var sheet = grid.CurrentWorksheet;
sheet.fun();

Access worksheet

Worksheet provides a lot of methods that could be used to manage cells data, styles, borders, outlines, ranges, formula calculation and etc. The below is an example that demos how to set cells data by call worksheet API.

Set cells data using worksheet index property:

// get current active worksheet instance
var sheet = grid.CurrentWorksheet;

// set cells data
sheet["A1"] = "hello world";
sheet[2, 1] = 10;

Or call SetCellData method:

sheet.SetCellData(new CellPosition(2, 1), "hello world");

Learn more about worksheet.