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;
}
}
