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); } }