ReoGrid is fully available in VB.NET since it is developed by C#.NET, both languages are .NET Framework based.
Make spreadsheet template by Excel
From the version 0.8.8, ReoGrid supports that load and save Excel(xlsx) file. It’s possible to make any spreadsheet templates by Excel, and show them in any .NET application with ReoGrid 0.8.8. See Excel file format support.
Make spreadsheet template by ReoGridEditor
Put ReoGrid on Windows Form
To put ReoGrid on a windows from in VB.NET use the code like this:
Dim grid As New unvell.ReoGrid.ReoGridControl grid.Dock = DockStyle.Fill Me.Controls.Add(grid) 'Get default worksheet instance Dim sheet = grid.CurrentWorksheet 'Set cell value sheet("A1") = "A"
Load template spreadsheet
Load Excel format template from stream:
'Load from file grid.Load("C:\mypath\template.xlsx"); 'Load from stream Using s As New System.IO.FileStream("C:\mypath\template.xlsx", _ IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read) grid.Load(s, IO.FileFormat.Excel2007) End Using
Load ReoGrid format template from stream:
'Load from file sheet.Load("C:\mypath\template.rgf") 'Load from stream Using s As New System.IO.FileStream("C:\mypath\template.rgf", _ IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read) sheet.Load(s, IO.FileFormat.ReoGridFormat) End Using
Form shows spreadsheet like this:
Hide sheet tab control and scroll bars
ReoGrid has WorkbookSettings and WorksheetSettings, what are used to decide many of spreadsheet behaviors and appearance. Sheet tab control and scroll bars are a part of workbook appearance, they could be hidden by following settings:
grid.SetSettings(WorkbookSettings.View_ShowSheetTabControl Or _ WorkbookSettings.View_ShowScrolls, False)
Hide spreadsheet headers
The row header and column header are a part of each worksheet, to hide the headers of current selected worksheet, use the following code:
The form shows spreadsheet like this:
Learn more about how to use ReoGrid
- Download the build package and run Demo program
- Check the Demo program source code to learn how to use ReoGrid (Demo programs are written in C#.NET but all code translate to VB.NET it will work properly)
- Check documentation for API usage
- Post your questions in forum