function main(spreadsheetReport) {
// 获取电子表格参数面板
var lastCell = spreadsheetReport.paramPanelObj;
var paramTable = spreadsheetReport.paramPanelObj.layoutTable;
var i, cell;
// 在参数同一行添加按钮
for (i = 0; i < paramTable.rows.length; i++) {
cell = paramTable.rows[i].insertCell(-1);
if (i == paramTable.rows.length - 1)
lastCell = cell;
}
// 在参数后面一行添加按钮,可以使用如下代码
/*var row = paramTable.insertRow();
row.style.height = "20px";
lastCell = row.insertCell( - 1);
lastCell.colSpan = paramTable.rows[0].cells.length;
lastCell.align = "center";*/
if (!spreadsheetReport._newBtn) {// 不重复添加按钮
var input = document.createElement("INPUT");
input.type = "button";
input.value = "刷新按钮";
input.title = "刷新按钮";
input.style.width = "100";
input.style.height = "20";
var newBtn = lastCell.appendChild(input);
spreadsheetReport.addListener(input, "click", doNewButtonClick,
spreadsheetReport);
spreadsheetReport._newBtn = newBtn;
}
// 新添加按钮Click事件处理函数
function doNewButtonClick(e) {
spreadsheetReport.doRefresh();
spreadsheetReport.doRefresh(true);// 刷新报表
}
}