private int GetIdBorder(eStyleClass styleClass, eStyleProperty styleProperty, object value)
{
ExcelBorderXml border = Border.Copy();
switch (styleClass)
{
case eStyleClass.BorderBottom:
SetBorderItem(border.Bottom, styleProperty, value);
break;
case eStyleClass.BorderDiagonal:
SetBorderItem(border.Diagonal, styleProperty, value);
break;
case eStyleClass.BorderLeft:
SetBorderItem(border.Left, styleProperty, value);
break;
case eStyleClass.BorderRight:
SetBorderItem(border.Right, styleProperty, value);
break;
case eStyleClass.BorderTop:
SetBorderItem(border.Top, styleProperty, value);
break;
case eStyleClass.Border:
if (styleProperty == eStyleProperty.BorderDiagonalUp)
{
border.DiagonalUp = (bool)value;
}
else if (styleProperty == eStyleProperty.BorderDiagonalDown)
{
border.DiagonalDown = (bool)value;
}
else
{
throw (new Exception("Invalid property for class Border."));
}
break;
default:
throw (new Exception("Invalid class/property for class Border."));
}
int subId;
string id = border.Id;
subId = _styles.Borders.FindIndexByID(id);
if (subId == int.MinValue)
{
return(_styles.Borders.Add(id, border));
}
return(subId);
}
internal ExcelBorderXml Copy()
{
ExcelBorderXml newBorder = new ExcelBorderXml(NameSpaceManager);
newBorder.Bottom = _bottom.Copy();
newBorder.Diagonal = _diagonal.Copy();
newBorder.Left = _left.Copy();
newBorder.Right = _right.Copy();
newBorder.Top = _top.Copy();
newBorder.DiagonalUp = _diagonalUp;
newBorder.DiagonalDown = _diagonalDown;
return(newBorder);
}
internal ExcelBorderXml Copy()
{
ExcelBorderXml newBorder = new ExcelBorderXml(NameSpaceManager);
newBorder.Bottom = _bottom.Copy();
newBorder.Diagonal = _diagonal.Copy();
newBorder.Left = _left.Copy();
newBorder.Right = _right.Copy();
newBorder.Top = _top.Copy();
newBorder.DiagonalUp = _diagonalUp;
newBorder.DiagonalDown = _diagonalDown;
return newBorder;
}
/// <summary>
/// Loads the style XML to memory
/// </summary>
private void LoadFromDocument()
{
//NumberFormats
ExcelNumberFormatXml.AddBuildIn(NameSpaceManager, NumberFormats);
XmlNode numNode = _styleXml.SelectSingleNode(NumberFormatsPath, _nameSpaceManager);
if (numNode != null)
{
foreach (XmlNode n in numNode)
{
ExcelNumberFormatXml nf = new ExcelNumberFormatXml(_nameSpaceManager, n);
NumberFormats.Add(nf.Id, nf);
if (nf.NumFmtId >= NumberFormats.NextId) NumberFormats.NextId=nf.NumFmtId+1;
}
}
//Fonts
XmlNode fontNode = _styleXml.SelectSingleNode(FontsPath, _nameSpaceManager);
foreach (XmlNode n in fontNode)
{
ExcelFontXml f = new ExcelFontXml(_nameSpaceManager, n);
Fonts.Add(f.Id, f);
}
//Fills
XmlNode fillNode = _styleXml.SelectSingleNode(FillsPath, _nameSpaceManager);
foreach (XmlNode n in fillNode)
{
ExcelFillXml f;
if (n.FirstChild != null && n.FirstChild.LocalName == "gradientFill")
{
f = new ExcelGradientFillXml(_nameSpaceManager, n);
}
else
{
f = new ExcelFillXml(_nameSpaceManager, n);
}
Fills.Add(f.Id, f);
}
//Borders
XmlNode borderNode = _styleXml.SelectSingleNode(BordersPath, _nameSpaceManager);
foreach (XmlNode n in borderNode)
{
ExcelBorderXml b = new ExcelBorderXml(_nameSpaceManager, n);
Borders.Add(b.Id, b);
}
//cellStyleXfs
XmlNode styleXfsNode = _styleXml.SelectSingleNode(CellStyleXfsPath, _nameSpaceManager);
if (styleXfsNode != null)
{
foreach (XmlNode n in styleXfsNode)
{
ExcelXfs item = new ExcelXfs(_nameSpaceManager, n, this);
CellStyleXfs.Add(item.Id, item);
}
}
XmlNode styleNode = _styleXml.SelectSingleNode(CellXfsPath, _nameSpaceManager);
for (int i = 0; i < styleNode.ChildNodes.Count; i++)
{
XmlNode n = styleNode.ChildNodes[i];
ExcelXfs item = new ExcelXfs(_nameSpaceManager, n, this);
CellXfs.Add(item.Id, item);
}
//cellStyle
XmlNode namedStyleNode = _styleXml.SelectSingleNode(CellStylesPath, _nameSpaceManager);
if (namedStyleNode != null)
{
foreach (XmlNode n in namedStyleNode)
{
ExcelNamedStyleXml item = new ExcelNamedStyleXml(_nameSpaceManager, n, this);
NamedStyles.Add(item.Name, item);
}
}
//dxfsPath
XmlNode dxfsNode = _styleXml.SelectSingleNode(dxfsPath, _nameSpaceManager);
if (dxfsNode != null)
{
foreach (XmlNode x in dxfsNode)
{
ExcelDxfStyleConditionalFormatting item = new ExcelDxfStyleConditionalFormatting(_nameSpaceManager, x, this);
Dxfs.Add(item.Id, item);
}
}
}