internal static string EncodeSelectionMode(WorksheetSelectionMode selMode) { switch (selMode) { default: case WorksheetSelectionMode.Range: return("range"); case WorksheetSelectionMode.Cell: return("cell"); case WorksheetSelectionMode.None: return("none"); case WorksheetSelectionMode.Row: return("row"); case WorksheetSelectionMode.Column: return("column"); } }
/// <summary> /// 初始化ReoGrid表格,注意:只会保留KeyName中Visible=true的列和"ID"列! /// </summary> /// <param name="reoGrid"></param> /// <param name="keyNames"></param> /// <param name="selectionMode"></param> public static void InitReoGrid(ReoGridControl reoGrid, KeyName[] keyNames, WorksheetSelectionMode selectionMode = WorksheetSelectionMode.Row) { //初始化表格 reoGrid.SetSettings(WorkbookSettings.View_ShowSheetTabControl, false); var worksheet = reoGrid.Worksheets[0]; worksheet.SelectionMode = selectionMode; keyNames = (from kn in keyNames where kn.Visible == true || kn.Key == "ID" select kn).ToArray(); for (int i = 0; i < keyNames.Length; i++) { worksheet.ColumnHeaders[i].Text = keyNames[i].Name; worksheet.ColumnHeaders[i].IsVisible = keyNames[i].Visible; } worksheet.Columns = keyNames.Length; //限制表的长度 }