public WorksheetModel(ReoGridControl reoGridControl, Type recordModelType) { _ReoGridControl = reoGridControl; _Worksheet = reoGridControl.CurrentWorksheet; _RecordModelType = recordModelType; _Records = new ObservableCollection <IRecordModel>(); InitWorksheet(); }
public WorksheetModel(ReoGridControl reoGridControl, Type recordModelType, ObservableCollection <IRecordModel> records) { _ReoGridControl = reoGridControl; _Worksheet = reoGridControl.CurrentWorksheet; _Records = records; _RecordModelType = recordModelType; _Records.CollectionChanged += Records_CollectionChanged; InitWorksheet(); }
private void sheet_CellMouseDown(object sender, CellMouseEventArgs e) { unvell.ReoGrid.Worksheet sheet = reoGridControl.CurrentWorksheet; Cell cell = sheet.CreateAndGetCell(e.CellPosition); //MessageBox.Show((cell.Row+1)+" "+(cell.Column+1)); txtRow.Text = (cell.Row + 1).ToString(); txtColumn.Text = (cell.Column + 1).ToString(); txtSheet.Text = sheet.Name; }
private void Index_Load(object sender, EventArgs e) { setControl = new Set(); setControl.SetEvent += SetControl_SetEvent; homeControl = new ViewReport(); view = new Controls.View(); navigate1.NavigateEvent += Navigate1_NavigateEvent; navigateTabContent.Controls.Add(homeControl); importExcel = new Controls.ImportExcel(); sheet = homeControl.sheet; workBook = homeControl.workBook; //this.Closed += Index_Closed; //sheet.DeleteRows(0, 2);//删除模板第一行 }
private void ViewReport_Load(object sender, EventArgs e) { //sheet.InsertColumns(0,23); dataReport = new DataReportLogic(); selects = new List <Company>(); InitHeader(); sheet = excel.CurrentWorksheet; sheet.DeleteRows(0, 2);//删除模板1、2行 //LoadData(); LoadSelectItems(); sheet.SetCols(22); sheet.Resize(200, 22); sheet.BeforeCellEdit += (s, ev) => ev.IsCancelled = true; if (comboBox1.Items.Count > 0) { comboBox1.SelectedIndex = 0; } ExcelHelper.SetDecimalFormat(sheet, 2); sheet.AutoFitColumnWidth(0, false); }
private void Navigate1_NavigateEvent(object sender, MessageEventArgs e) { navigateTabContent.Controls.Clear(); currentOperation = e.Message; switch (e.Message) { case "Home": homeControl = new ViewReport(); navigateTabContent.Controls.Add(homeControl); sheet = homeControl.sheet; workBook = homeControl.workBook; break; case "Import": importExcel = new Controls.ImportExcel(); navigateTabContent.Controls.Add(importExcel); sheet = null; break; case "View": view = new Controls.View(); navigateTabContent.Controls.Add(view); sheet = view.sheet; workBook = view.workBook; break; case "Set": setControl = new Set(); navigateTabContent.Controls.Add(setControl); sheet = null; break; case "ModifyPassword": break; } }
public static void GetActualizedRange(unvell.ReoGrid.Worksheet CW, out int maxRow, out int maxCol) { unvell.ReoGrid.RangePosition ColumnCaptionRange = new unvell.ReoGrid.RangePosition(row: 0, col: 0, rows: 1, cols: CW.ColumnCount); int maxCaptionCol = -1; CW.IterateCells(range: ColumnCaptionRange, iterator: (row, col, cell) => { if (cell.DataFormat == CellDataFormatFlag.Text) { string text = cell.GetData <String> ( ); if (text == null) { return(false); } maxCaptionCol = col; return(true); } if (cell.DataFormat == CellDataFormatFlag.General) { string text = cell.GetData <String> ( ); if (text == null) { return(false); } maxCaptionCol = col; return(true); } return(false); } ); maxCol = maxCaptionCol; unvell.ReoGrid.RangePosition RowCaptionRange = new unvell.ReoGrid.RangePosition(row: 0, col: 0, rows: CW.RowCount, cols: 1); int maxCaptionRow = -1; CW.IterateCells(range: RowCaptionRange, iterator: (row, col, cell) => { if (cell.DataFormat == CellDataFormatFlag.Text) { string text = cell.GetData <String> ( ); if (text == null) { return(false); } maxCaptionRow = row; return(true); } if (cell.DataFormat == CellDataFormatFlag.General) { string text = cell.GetData <String> ( ); if (text == null) { return(false); } maxCaptionRow = row; return(true); } return(false); } ); maxRow = maxCaptionRow; return; }
/// <summary> /// Construct cell instance with specified owner grid instance. /// Cell instance managed by ReoGrid core, it cannot be created by user-code. /// </summary> /// <param name="worksheet">Owner grid control for this cell</param> internal Cell(Worksheet worksheet) { this.worksheet = worksheet; this.FontDirty = true; }
internal ReoGridCell(Worksheet worksheet) : base(worksheet) { }
internal NamedRangeCollection(Worksheet sheet) { this.sheet = sheet; }
/// <summary> /// Create named range from specified worksheet and address /// </summary> /// <param name="worksheet">worksheet to hold this named range</param> /// <param name="name">name to identify this range on spreadsheet</param> /// <param name="range">address identifier to locate a range on spreadsheet</param> public NamedRange(Worksheet worksheet, string name, RangePosition range) : this(worksheet, name, range.StartPos, range.EndPos) { }
/// <summary> /// Create named range from specified worksheet and address /// </summary> /// <param name="worksheet">worksheet to hold this named range</param> /// <param name="name">name to identify this range on spreadsheet</param> /// <param name="address">address identifier to locate a range on spreadsheet</param> public NamedRange(Worksheet worksheet, string name, string address) : this(worksheet, name, new RangePosition(address)) { }