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