void AddTabBarPage()
{
TabBarPage page = new TabBarPage("Sheet" + (this.tabBarSplitterControl1.TabBarPages.Count + 1));
grid = CreateGridControl();
page.Controls.Add(grid);
grid.ThemesEnabled = true;
grid.GridVisualStyles = GridVisualStyles.Metro;
this.tabBarSplitterControl1.TabBarPages.Add(page);
}
/// <summary>
/// Used to load the all worksheets and assign those sheets in grid models.
/// </summary>
/// <param name="Workbook">Exel work book that needs to be imported.</param>
public void LoadWorkbook(TabBarSplitterControl formTabBarSplitterControl, IWorkbook Workbook)
{
tabBarSplitterControl = formTabBarSplitterControl;
formTabBarSplitterControl.TabBarPages.Clear();
workbook = Workbook;
GridExcelConverterControl extensions = new GridExcelConverterControl();
gridModelCollection = extensions.ExcelToVirtualGrid(Workbook);
for (int i = 0; i < Workbook.Worksheets.Count; i++)
{
GridControl grid = new GridControl();
//Used to calculate the formula values.
Workbook.Worksheets[i].EnableSheetCalculations();
#region Adding Tab pages
TabBarPage tab = new TabBarPage();
tab.Text = Workbook.Worksheets[i].Name;
tab.Controls.Add(grid);
if (Workbook.Worksheets[i].Visibility != WorksheetVisibility.Visible)
{
tab.Visible = false;
}
#endregion
#region GridModel settings
grid.Model = gridModelCollection[i];
#endregion
#region Grid customization
grid.ThemesEnabled = true;
GridMetroColors colors = new GridMetroColors();
colors.HeaderBottomBorderColor = Color.FromArgb(208, 208, 208);
colors.HeaderBottomBorderWeight = GridBottomBorderWeight.Thin;
grid.SetMetroStyle(colors);
grid.FloatCellsMode = GridFloatCellsMode.OnDemandCalculation;
grid.ExcelLikeAlignment = true;
grid.Model.Options.ExcelLikeCurrentCell = true;
grid.Model.Options.ExcelLikeSelectionFrame = true;
grid.Model.Options.EnterKeyBehavior = GridDirectionType.Down;
grid.ActivateCurrentCellBehavior = GridCellActivateAction.DblClickOnCell;
grid.Model.Options.WrapCell = false;
grid.Model.CommandStack.Enabled = true;
grid.Properties.ForceImmediateRepaint = true;
grid.Model.ColWidths[0] = 35;
grid.SmoothMouseWheelScrolling = true;
RegisterCellModel.GridCellType(grid, CustomCellTypes.LinkLabelCell);
#endregion
formTabBarSplitterControl.TabBarPages.Add(tab);
}
formTabBarSplitterControl.ActivePageIndex = 0;
foreach (GridModel gridModel in gridModelCollection)
{
gridModel.QueryCellInfo += new GridQueryCellInfoEventHandler(Model_QueryCellInfo);
gridModel.SaveCellInfo += new GridSaveCellInfoEventHandler(gridModel_SaveCellInfo);
}
}
