/*
合并单元格并居中
@param sRow 开始列
@param eRow 结束列
@param sCol 开始行
@param eCol 结束行
*/
function mergeCellAndCenter(JavaScriptObject spread,int sRow,int eRow,int sCol,int eCol,String text)
{
var activeSheet = spread.getActiveSheet();
var rowCount = eRow - sRow + 1;
var colCount = eCol - sCol + 1;
//获得当前sheet中已经合并的单元格数组
var spans= activeSheet.getSpans();
if(spans.length > 0){
for(var i=0;i<spans.length;i++){
if(spans[i].row == sRow && spans[i].col == sCol) activeSheet.removeSpan(sRow,sCol);//取消合并
else{
//合并单元格
activeSheet.addSpan(sRow,sCol,rowCount,colCount);
activeSheet.getCell(sRow,sCol).value(text).hAlign(1).vAlign(1);
}
}
}else{
activeSheet.addSpan(sRow,sCol,rowCount,colCount);
activeSheet.getCell(sRow,sCol).value(text).hAlign(1).vAlign(1);
}
}