public CT_MergeCell AddNewMergeCell()
{
CT_MergeCell mergecell = new CT_MergeCell();
mergeCell.Add(mergecell);
return(mergecell);
}
public static CT_MergeCell Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
return null;
CT_MergeCell ctObj = new CT_MergeCell();
ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]);
return ctObj;
}
public static CT_MergeCell Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_MergeCell ctObj = new CT_MergeCell();
ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]);
return(ctObj);
}
public static CT_MergeCells Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_MergeCells ctObj = new CT_MergeCells();
ctObj.count = XmlHelper.ReadUInt(node.Attributes["count"]);
ctObj.mergeCell = new List <CT_MergeCell>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "mergeCell")
{
ctObj.mergeCell.Add(CT_MergeCell.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
/**
* Removes a merged region of cells (hence letting them free)
*
* @param index of the region to unmerge
*/
public void RemoveMergedRegion(int index)
{
CT_MergeCells ctMergeCells = worksheet.mergeCells;
CT_MergeCell[] mergeCellsArray = new CT_MergeCell[ctMergeCells.sizeOfMergeCellArray() - 1];
for (int i = 0; i < ctMergeCells.sizeOfMergeCellArray(); i++)
{
if (i < index)
{
mergeCellsArray[i] = ctMergeCells.GetMergeCellArray(i);
}
else if (i > index)
{
mergeCellsArray[i - 1] = ctMergeCells.GetMergeCellArray(i);
}
}
if (mergeCellsArray.Length > 0)
{
ctMergeCells.SetMergeCellArray(mergeCellsArray);
}
else
{
worksheet.UnsetMergeCells();
}
}
/**
* Removes a number of merged regions of cells (hence letting them free)
*
* This method can be used to bulk-remove merged regions in a way
* much faster than calling RemoveMergedRegion() for every single
* merged region.
*
* @param indices A Set of the regions to unmerge
*/
public void RemoveMergedRegions(HashSet<int> indices)
{
CT_MergeCells ctMergeCells = worksheet.mergeCells;
int size = ctMergeCells.sizeOfMergeCellArray();
CT_MergeCell[] mergeCellsArray = new CT_MergeCell[size - indices.Count];
for (int i = 0, d = 0; i < size; i++)
{
if (!indices.Contains(i))
{
mergeCellsArray[d] = ctMergeCells.GetMergeCellArray(i);
d++;
}
}
if (mergeCellsArray.Length > 0)
{
ctMergeCells.SetMergeCellArray(mergeCellsArray);
}
else
{
worksheet.UnsetMergeCells();
}
}
public CT_MergeCell AddNewMergeCell()
{
CT_MergeCell mergecell = new CT_MergeCell();
mergeCell.Add(mergecell);
return mergecell;
}
public void SetMergeCellArray(CT_MergeCell[] array)
{
mergeCell = new List<CT_MergeCell>(array);
}