public void Load(XmlNode columnNode)
{
SetProperties(columnNode);
if (Index < 0 && !string.IsNullOrEmpty(ColumnLetter))
{
Index = Degatech.Utilities.IO.File.Convertors.Excel.ExcelColumnNameToNumber(ColumnLetter) - 1;
}
else if (Index > -1 && string.IsNullOrEmpty(ColumnLetter))
{
ColumnLetter = Degatech.Utilities.IO.File.Convertors.Excel.GetExcelColumnNameFromNumber(Index + 1);
}
if (columnNode.Attributes["Name"] != null)
{
_Name = columnNode.Attributes["Name"].Value;
}
//Load all filters
if (columnNode["Filters"] != null)
{
_Filters.Load(columnNode["Filters"]);
}
//Load all calculations
if (columnNode["Calculations"] != null)
{
_Calculations.Load(columnNode["Calculations"]);
}
//Load all string operations
if (columnNode["StringOperations"] != null)
{
_StringOperations.Load(columnNode["StringOperations"]);
}
//Load conditional operation
if (columnNode["ConditionalOperation"] != null)
{
ConditionalOperation.Load(columnNode["ConditionalOperation"]);
}
}
