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:
- Right-click on Toolbox panel, click ‘Choose Items…’
- Choose ‘.NET Framework Components tab’
- Click ‘Browse…’ button
- Choose ‘unvell.ReoGrid.dll’ in open file dialog
- Click OK button to close the dialog
- 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)
DLL Name | Description | Minimum Edition |
Standard Release Edition |
Extension Edition |
---|---|---|---|---|
unvell.ReoGrid.dll | ReoGrid component library | Required | Required | Required |
unvell.ReoScript.dll | .NET script language engine | Required | ||
Antlr3.Runtime.dll | ANTLR grammar tool run-time | Required | ||
FastColoredTextBox.dll | Powerful colored highlight text editor | Required |
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
Learn more about workbook and worksheet.
Add Windows Form Control in VB.NET
1. Import namespaces:
Imports unvell.ReoGrid
2. Create ReoGrid instance and add it into any windows form container, such as Form or Panel.
Dim grid As New MyReoGridControl() With {.Dock = DockStyle.Fill} Me.Controls.Add(grid)
Add Control in XAML for WPF Applications
Add ReoGrid DLL reference for target project, edit the XAML file of main window as 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
For more about WPF edition, see WPF support.
the install fails if you install the forms version and/or the WPF version. The control appears not under
.NET Framework component but under WPF control
Thanks! We will improvement the document to make it more clear.
Is it available for web applications like mvc
No, ReoGrid doesn’t support web applications.