C#在Excel中将连续多列相同数据项合并

怼烎@ 2022-08-26 03:58 400阅读 0赞

效果图如下：

![20080306134707289.jpg][]

<table> 
 <tbody> 
 <tr> 
 <td>&nbsp;/**//// &lt;summary&gt; /// 合并工作表中指定行数和列数数据相同的单元格 /// &lt;/summary&gt; /// &lt;param name="sheetIndex"&gt;工作表索引&lt;/param&gt; /// &lt;param name="beginRowIndex"&gt;开始行索引&lt;/param&gt; /// &lt;param name="beginColumnIndex"&gt;开始列索引&lt;/param&gt; /// &lt;param name="rowCount"&gt;要合并的行数&lt;/param&gt; /// &lt;param name="columnCount"&gt;要合并的列数&lt;/param&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public void MergeWorkSheet(int sheetIndex,int beginRowIndex,int beginColumnIndex,int rowCount,int columnCount) { //检查参数 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( columnCount &lt; 1 || rowCount &lt; 1) return ; for(int col=0;col&lt;columnCount;col++) { int mark = 0;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //标记比较数据中第一条记录位置 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int mergeCount = 1;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //相同记录数，即要合并的行数 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string text = ""; for(int row=0;row&lt;rowCount;row++) { string prvName = ""; string nextName = ""; //最后一行不用比较 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if( row + 1 &lt; rowCount) { for(int n=0;n&lt;=col;n++) { range = (Excel.Range)workSheet.Cells[row + beginRowIndex,n + beginColumnIndex]; range = (Excel.Range)range.MergeArea.get_Item(1,1); text = range.Text.ToString(); prvName = prvName + text; range = (Excel.Range)workSheet.Cells[row + 1 + beginRowIndex,n + beginColumnIndex]; range = (Excel.Range)range.MergeArea.get_Item(1,1); nextName = nextName + range.Text.ToString(); } if(prvName == nextName) { mergeCount++; if(row == rowCount - 2) { this.MergeCells(sheetIndex,beginRowIndex + mark,beginColumnIndex + col,beginRowIndex + mark + mergeCount - 1,beginColumnIndex + col,text); } } else { this.MergeCells(sheetIndex,beginRowIndex + mark,beginColumnIndex + col,beginRowIndex + mark + mergeCount - 1,beginColumnIndex + col,text); mergeCount = 1; mark = row + 1; } } } } }</td> 
 </tr> 
 </tbody> 
</table>

[20080306134707289.jpg]: http://dotnet.chinaitlab.com/UploadFiles_6597/200803/20080306134707289.jpg