public bool Merge(WorkbookColumn column)
{
if (Title == column.Title)
{
// To this.Cells add all the cells from the second column without header
var cells = column.Cells.GetRange(1, column.Cells.Count - 1);
Cells.AddRange(cells);
return(true);
}
return(false);
}
public bool Merge(WorkbookSheet other)
{
if (!WorkbookHeader.Merge(other.WorkbookHeader))
{
return(false);
}
WorkbookColumn[] backupColumns = new WorkbookColumn[Columns.Count];
Columns.CopyTo(backupColumns);
for (int i = 0; i < Columns.Count; i++)
{
var column = Columns[i];
if (!column.Merge(other.Columns[i]))
{
Columns = backupColumns.ToList();
return(false);
}
Columns[i] = column;
}
Rows.AddRange(other.Rows);
return(true);
}