private Worksheet CreateWorkSheet() { Worksheet sheet = m_TableGridControl.NewWorksheet(); string name = NewWorkSheetName(); InitializeSheet(sheet, name); return(sheet); }
void ParseOldData() { //var separator = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ListSeparator; var separator = ";"; var esheet = Sheet.NewWorksheet("EXPORTS"); List <Tuple <string, string, string, string> > elist = new List <Tuple <string, string, string, string> >(); int i, j; Cell cell; for (i = 0; (i <= (Sheet.Worksheets[0].RowCount - 1)); i++) { for (j = 0; (j <= (Sheet.Worksheets[0].ColumnCount - 1)); j++) { cell = Sheet.Worksheets[0].Cells[i, j]; ccparams = (SpreadsheetCellParameters)cell.Tag; if (!(ccparams == null)) { var expression = ccparams.Expression; switch (ccparams.CellType) { case SharedClasses.Spreadsheet.VarType.Expression: case SharedClasses.Spreadsheet.VarType.Read: if ((expression != "")) { if ((expression.Substring(0, 1) == "=")) { cell.Formula = expression.TrimStart('=').ToUpper(); cell.Style.BackColor = Colors.LightYellow.ToSolidColor(); } else if ((expression.Substring(0, 1) == ":")) { string[] str; string obj; string prop; str = expression.Split(new char[] { ',' }); obj = str[0].Substring(1); ccparams.ObjectID = obj; if ((str.Length < 3)) { prop = str[1]; } else { prop = (str[1] + ("," + str[2])); } ccparams.PropID = prop; cell.Formula = string.Format("GETPROPVAL({3}{0}{3}{1}{3}{2}{3})", obj, separator, prop, '\"'); cell.Style.BackColor = Colors.LightGreen.ToSolidColor(); } else { cell.Data = expression; if (((ccparams.CellType != SharedClasses.Spreadsheet.VarType.Write) && (ccparams.CellType != SharedClasses.Spreadsheet.VarType.Unit))) { ccparams.ToolTipText = expression; } } } break; case SharedClasses.Spreadsheet.VarType.Unit: cell.Style.BackColor = Colors.Beige.ToSolidColor(); break; case SharedClasses.Spreadsheet.VarType.Write: if ((expression.Substring(0, 1) == "=")) { cell.Formula = expression.TrimStart('=').ToUpper(); if (!(ccparams.CellType == SharedClasses.Spreadsheet.VarType.Write)) { cell.Style.BackColor = Colors.LightYellow.ToSolidColor(); } else { cell.Data = expression; if (((ccparams.CellType != SharedClasses.Spreadsheet.VarType.Write) && (ccparams.CellType != SharedClasses.Spreadsheet.VarType.Unit))) { ccparams.ToolTipText = expression; } } elist.Add(new Tuple <string, string, string, string>(string.Format("SETPROPVAL({4}{1}{4}{0}{4}{2}{4}{0}{4}{3}{4})", separator, ccparams.ObjectID, ccparams.PropID, ("MAIN!" + cell.Address), '\"'), ccparams.ObjectID, ccparams.PropID, ccparams.PropUnit)); cell.Style.BackColor = Colors.LightBlue.ToSolidColor(); } break; } } } } esheet.Cells[0, 0].Data = "EXPRESSION"; esheet.Cells[0, 1].Data = "OBJECT"; esheet.Cells[0, 2].Data = "PROPERTY"; esheet.Cells[0, 3].Data = "UNITS"; esheet.Cells[0, 0].Style.Bold = true; esheet.Cells[0, 1].Style.Bold = true; esheet.Cells[0, 2].Style.Bold = true; esheet.Cells[0, 3].Style.Bold = true; i = 1; foreach (var item in elist) { esheet.Cells[i, 0].Formula = item.Item1; esheet.Cells[i, 1].Data = flowsheet.SimulationObjects[item.Item2].GraphicObject.Tag; esheet.Cells[i, 2].Data = item.Item3; esheet.Cells[i, 3].Data = item.Item4; } }