void AssociatedObject_WorkBookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (var gridModel in args.GridCollection)
{
gridModel.Model.CommandStack.Enabled = true;
}
}
void AssociatedObject_WorkBookLoaded(object sender, WorkbookLoadedEventArgs args)
{
for (int i = 0; i < args.GridCollection.Count; i++)
{
args.GridCollection[i].ZoomScale = this.AssociatedObject.ExcelProperties.WorkBook.Worksheets[i].Zoom / 100.00;
}
}
void AssociatedObject_WorkBookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (GridControlBase grid in args.GridCollection)
{
grid.Model.GraphicModel.CellModels.Add("Chart", new GraphicChartCellModel());
}
}
void AssociatedObject_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (var grid in args.GridCollection)
{
grid.CurrentCellBeginEdit += grid_CurrentCellBeginEdit;
grid.CurrentCellEndEdit += grid_CurrentCellEndEdit;
}
}
private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
//To hide the Header cells visibility
foreach (var worksheet in spreadsheet.Workbook.Worksheets)
{
var grid = spreadsheet.GridCollection[worksheet.Name];
grid.RowHeights.SetHidden(0, 0, true);
grid.ColumnWidths.SetHidden(0, 0, true);
}
}
private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (var grid in args.GridCollection)
{
grid.CreateGridColumn = CreateSpreadsheetColumnExt;
var renderer = new SpreadsheetTemplateCellRenderer();
grid.CellRenderers.Add("ArrowTemplate", renderer);
grid.QueryRange += Grid_QueryRange;
spreadsheet.SetRowColumnHeadersVisibility(false);
}
spreadsheet.Protect(true, true, "");
spreadsheet.ProtectSheet(spreadsheet.ActiveSheet, "", Syncfusion.XlsIO.ExcelSheetProtection.None);
}
private void InputSpread_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
string sheetName;
for (int sheets = 0; sheets < InputSpread.Workbook.Worksheets.Count; sheets++)
{
sheetName = InputSpread.Workbook.Worksheets[sheets].Name;
int adopted = 0;
for (int col0 = 1; col0 < InputSpread.ActiveSheet.UsedRange.LastColumn + 1; col0++)
{
if (adopted == 0)
{
for (int v = 0; v < 4; v++)
{
if (InputSpread.ActiveSheet.Range[2, col0].Value.ToString() == ColArgs[v])
{
adopted = 1;
}
}
}
else
{
for (int col4 = 1; col4 < InputSpread.ActiveSheet.UsedRange.LastColumn + 1; col4++)
{
InputSpread.ActiveSheet.Range[2, col4].CellStyle.Color = colors[Int32.Parse(InputSpread.ActiveSheet.Range[1, col4].Value)];
InputSpread.ActiveSheet.Range[2, col4].CellStyle.Locked = true;
InputSpread.ActiveGrid.InvalidateCell(2, col4);
}
break;
}
}
if (adopted == 0)
{
InputSpread.SetActiveSheet(sheetName);
InputSpread.ActiveSheet.InsertRow(1, 2);
int lastcol = InputSpread.ActiveSheet.UsedRange.LastColumn + 1;
InputSpread.ActiveGrid.FrozenRows = 3;
for (int col = 1; col < lastcol; col++)
{
InputSpread.ActiveSheet.Range[1, col].Value = "0";
InputSpread.ActiveSheet.Range[2, col].Value = ColArgs[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Color = colors[Int32.Parse(InputSpread.ActiveSheet.Range[1, col].Value)];
InputSpread.ActiveSheet.Range[2, col].CellStyle.Locked = true;
}
}
InputSpread.ActiveSheet.CellValueChanged += ActiveSheet_CellValueChanged;
InputSpread.ActiveGrid.Model.ColumnsInserted += Model_ColumnsInserted;
}
}
/// <summary>
/// Set the Products table when workbook loaded into the spreadsheet.
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
//Get the product Data table from the NorthWind datasource.
DataTable datatable = Data.GetDataTable("Products");
this.spreadsheet.ActiveSheet.ImportDataTable(datatable, true, 1, 1);
this.spreadsheet.ActiveGrid.InvalidateCells();
//AutoFit column width based on the imported data table's column width.
for (int i = 1; i <= spreadsheet.ActiveSheet.UsedRange.LastColumn; i++)
{
spreadsheet.ActiveSheet.AutofitColumn(i);
spreadsheet.ActiveGrid.SetColumnWidth(i, i, spreadsheet.ActiveSheet.GetColumnWidthInPixels(i));
}
}
//To change the cellstyle while importing the sheet.
private void SpreadSheetControl_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (IWorksheet sheet in args.Workbook.Worksheets)
{
if (sheet.UsedRange.LastRow > 0 && sheet.UsedRange.LastColumn > 0)
{
var cellStyle = sheet.UsedRange.CellStyle;
cellStyle.Font.FontName = "Arial Black";
cellStyle.Font.Bold = true;
cellStyle.Font.Color = ExcelKnownColors.Violet;
cellStyle.Font.Size = 12;
cellStyle.HorizontalAlignment = ExcelHAlign.HAlignLeft;
cellStyle.Borders.LineStyle = ExcelLineStyle.Double;
}
}
}
//Event Customization
private void Spreadsheet_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args)
{
spreadsheet.Visibility = Visibility.Visible;
}
