private void parseMegreCells(Worksheet worksheet, XWorksheet xWorksheet)
{
foreach (MergeCells mergeCells in worksheet.Descendants <MergeCells>())
{
foreach (MergeCell mergeCell in mergeCells.Descendants <MergeCell>())
{
XMergeCell xmc = new XMergeCell(mergeCell.Reference);
xWorksheet.MergeCells.Add(xmc);
}
}
}
private void ApplyMerge()
{
for (int i = 0; i < MergeCells.Count; i++)
{
XMergeCell xmc = MergeCells[i];
string temp = (string)cellOuterHtml.Rows[xmc.RowIndex][xmc.ColumnIndex];
temp = temp.Replace("<td", "<td colspan='" + xmc.ColumnCount.ToString() + "' rowspan='" + "1" + "'");
for (int ri = xmc.RowIndex; ri < (xmc.RowIndex + 1); ri++)
{
for (int ci = xmc.ColumnIndex; ci < (xmc.ColumnIndex + xmc.ColumnCount); ci++)
{
cellOuterHtml.Rows[ri][ci] = "";
}
}
cellOuterHtml.Rows[xmc.RowIndex][xmc.ColumnIndex] = temp;
}
}
public void Add(XMergeCell xMergeCell)
{
Array.Resize <XMergeCell>(ref xmcs, Count + 1);
xmcs[Count++] = xMergeCell;
}