public void MergeExcel(string FileName, C1.Win.C1FlexGrid.C1FlexGrid fg)
{
try
{
oXL = new Excel.Application();
oWB = (Excel._Workbook)(oXL.Workbooks.Open(FileName, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value));
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
oSheet.UsedRange.Cells.Borders.Value = 1;
// Thực hiện Merge
C1.Win.C1FlexGrid.CellRange cr;
object obj;
for (int i = 0; i < fg.Rows.Count; i++)
{
if (fg.Rows[i].Visible)
{
for (int j = 0; j < fg.Cols.Count; j++)
{
if (fg.Cols[j].Visible)
{
cr = fg.GetMergedRange(i, j);
if ((!cr.IsSingleCell && (cr.r1 == i)) && (cr.c1 == j))
{
oRng = oSheet.get_Range(TinhToaDo(cr.r1 + 1, cr.c1 + 1), TinhToaDo(cr.r2 + 1, cr.c2 + 1));
obj = fg[i, j];
oRng.Value2 = string.Empty;
oRng.Merge(Missing.Value);
oRng.Value2 = ReturnValue(obj);
}
}
}
}
}
// Xóa các cột, hàng đã bị ẩn
for (int i = oSheet.UsedRange.Rows.Count - 1; i > 0; i--)
{
oRng = oSheet.get_Range("A" + i.ToString(), Missing.Value);
if ((bool)oRng.EntireRow.Hidden == true)
{
oRng.EntireRow.Delete(Excel.XlDirection.xlToRight);
}
}
for (int i = oSheet.UsedRange.Columns.Count - 1; i > 0; i--)
{
oRng = oSheet.get_Range(TinhToaDo(1, i), Missing.Value);
if ((bool)oRng.EntireColumn.Hidden == true)
{
oRng.EntireColumn.Delete(Excel.XlDirection.xlDown);
}
}
oWB.Save();
oXL.Visible = true;
}
catch (Exception ex)
{
//oXL.Quit();
throw ex;
}
}