自动合并table中相同的单元格以及java自动合并excel相同单元格

一.js版:

示例：

var tb = document.getElementById("testtable"); autoRowSpan(tb,0,0,tb.rows.length-1,true,3); //效果如下：

 

autoRowSpan(tb,0,0,tb.rows.length-1,false,null); autoRowSpan(tb,1,0,tb.rows.length-1,false,null); autoRowSpan(tb,2,0,tb.rows.length-1,false,null); //效果如下：

autoRowSpan(tb,2,0,tb.rows.length-1,true,0); //效果如下：

//付详细代码： /** *tbDom table 元素，tbody也可以 *colIndex 合并的列索引 *startRow 起始行号 *endRow 终止行号 *isForward 是否递进合并其他列 *forwardToIndex 递进至第几列 */ function autoRowSpan(tbDom,colIndex,startRow,endRow,isForward,forwardToIndex){ alert(colIndex+"|"+startRow+"|"+ endRow +"|"+ isForward +"|"+forwardToIndex ); var rowspanIdx = startRow;// var pos = 1; var compareValue = null; for(var i=startRow; i<=endRow; ++i){ if(i == startRow){//取得起始行数据 compareValue = tbDom.rows[i].cells[colIndex].innerText; }else{// var tmpValue = tbDom.rows[i].cells[colIndex].innerText; if(compareValue == tmpValue){//与起始行单元格相同，则隐藏当前单元格 pos++; tbDom.rows[i].cells[colIndex].style.display="none"; }else{与起始行单元格不同，则设置起始行rowspan，并更新变量数据 compareValue = tmpValue; if(pos>1){//存在相同单元格 tbDom.rows[rowspanIdx].cells[colIndex].rowSpan = pos; //是否递进合并下一列 if(isForward){ var nextColIndex = colIndex; var tmpStartRow = rowspanIdx; var tmpEndRow = rowspanIdx + pos -1 ; if(colIndex < forwardToIndex)nextColIndex++; if(colIndex > forwardToIndex)nextColIndex--; if(colIndex == forwardToIndex)return; doRowspanTask(autoRowSpan,tbDom,nextColIndex,tmpStartRow,tmpEndRow,isForward,forwardToIndex); } } pos = 1; rowspanIdx = i; } } } if(pos>1){ tbDom.rows[rowspanIdx].cells[colIndex].rowSpan = pos; //是否递进合并下一列 if(isForward){ var nextColIndex = colIndex; var tmpStartRow = rowspanIdx; var tmpEndRow = rowspanIdx + pos - 1 ; if(colIndex < forwardToIndex)nextColIndex++; if(colIndex > forwardToIndex)nextColIndex--; if(colIndex == forwardToIndex)return; doRowspanTask(autoRowSpan,tbDom,nextColIndex,tmpStartRow,tmpEndRow,isForward,forwardToIndex); } pos =1; rowspanIdx = rowspanIdx + pos -1; } } //防止递归过多导致内存溢出 function doRowspanTask(func){ if(typeof func =='function'){ var args = Array.prototype.slice.call(arguments,1); var f = function(){ func.apply(null,args); } return window.setTimeout(f,0); } }

java 版：

excel效果同js一样，这里就直接贴代码：

/** * * @param sheet * @param colIdx 合并的列 * @param startRow 起始行 * @param stopRow 结束行 * @param isForward 是否递进合并其它列 * @param forwardToColIdx 递进到的列 */ public void mergeRowCell(HSSFSheet sheet,int colIdx,int startRow,int stopRow ,boolean isForward,int forwardToColIdx){ String compareValue = null; int beginRow = startRow; int endRow = startRow; for(int i=startRow;i<=stopRow; ++i){ String value = sheet.getRow(i).getCell(colIdx).getRichStringCellValue()==null ? "":sheet.getRow(i).getCell(colIdx).getRichStringCellValue().toString(); if(i == startRow){ compareValue = value; }else{ if(compareValue.equals(value)){//相同，则设置重复的值为空 sheet.getRow(i).getCell(colIdx).setCellValue(""); endRow = i; }else {//不同，则合并之前相同的单元格 if(beginRow < endRow){ sheet.addMergedRegion(new CellRangeAddress(beginRow,endRow,colIdx,colIdx)); if(isForward){//递进合并下一列 int nextColIndex = colIdx; if(colIdx < forwardToColIdx){ nextColIndex ++; }else if(colIdx > forwardToColIdx){ nextColIndex --; }else{ return; } mergeRowCell(sheet, nextColIndex, beginRow, endRow, isForward, forwardToColIdx); } } compareValue = value; beginRow = i; endRow = i; } } } if(beginRow < endRow){ sheet.addMergedRegion(new CellRangeAddress(beginRow,endRow,colIdx,colIdx)); if(isForward){//递进合并下一列 int nextColIndex = colIdx; if(colIdx < forwardToColIdx){ nextColIndex ++; }else if(colIdx > forwardToColIdx){ nextColIndex --; }else{ return; } mergeRowCell(sheet, nextColIndex, beginRow, endRow, isForward, forwardToColIdx); } } }