有知道NPOI怎么合并Excel单元格的吗？

Question

不是手动输入，而是自动合并

Answer 1

private void ReportExportMergedCells(NPOI.SS.UserModel.ISheet sheet, string strFields)
{

int iCol = 0, iR = 0, iR1 = 0;
string strValue1 = string.Empty;

if (strFields != "" && !strFields.StartsWith(",")) strFields = "," + strFields;
if (strFields != "" && !strFields.EndsWith(",")) strFields += ",";
foreach (NPOI.SS.UserModel.ICell cell in sheet.GetRow(0).Cells)
{
if (strFields != "" && !strFields.Contains("," + cell.ToString() + ","))
{
iCol++;
continue;
}
iR1 = iR = 0;
strValue1 = string.Empty;
foreach (NPOI.SS.UserModel.IRow irow in sheet)
{
if (iR1 == 0)
{
strValue1 = irow.Cells[iCol].ToString();
iR1 = iR;
}
else if (strValue1 != irow.Cells[iCol].ToString())
{
if ((iR - 1) >= iR1)
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(iR1, iR - 1, iCol, iCol));
strValue1 = irow.Cells[iCol].ToString();
iR1 = iR;
}
else if (iR == (sheet.LastRowNum))//
{
if (strValue1 == irow.Cells[iCol].ToString())
{
if ((iR - 1) >= iR1)
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(iR1, iR, iCol, iCol));
}
}

iR++;
}
iCol++;
}
}本回答被网友采纳

Answer 2

可以试一下 单元格里面有个两端对齐 适合将单元格里的数据合并到一格（前提是要将所在的列拉开的足够宽）

Answer 3

private void ReportExportMergedCells(NPOI.SS.UserModel.ISheet sheet, string strFields)
{

int iCol = 0, iR = 0, iR1 = 0;
string strValue1 = string.Empty;

if (strFields != "" && !strFields.StartsWith(",")) strFields = "," + strFields;
if (strFields != "" && !strFields.EndsWith(",")) strFields += ",";
foreach (NPOI.SS.UserModel.ICell cell in sheet.GetRow(0).Cells)
{
if (strFields != "" && !strFields.Contains("," + cell.ToString() + ","))
{
iCol++;
continue;
}
iR1 = iR = 0;
strValue1 = string.Empty;
foreach (NPOI.SS.UserModel.IRow irow in sheet)
{
if (iR1 == 0)
{
strValue1 = irow.Cells[iCol].ToString();
iR1 = iR;
}
else if (strValue1 != irow.Cells[iCol].ToString())
{
if ((iR - 1) >= iR1)
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(iR1, iR - 1, iCol, iCol));
strValue1 = irow.Cells[iCol].ToString();
iR1 = iR;
}
else if (iR == (sheet.LastRowNum))//
{
if (strValue1 == irow.Cells[iCol].ToString())
{
if ((iR - 1) >= iR1)
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(iR1, iR, iCol, iCol));
}
}

iR++;
}
iCol++;
}
}本回答被网友采纳

Answer 4

可以试一下 单元格里面有个两端对齐 适合将单元格里的数据合并到一格（前提是要将所在的列拉开的足够宽）