...
代码块 | ||||||
---|---|---|---|---|---|---|
| ||||||
function main(spreadsheetReport) { //获取当前sheet,从0开始计数 var sheet = spreadsheetReport.workbook.getWorksheets().get(0); var type = spreadsheetReport.outputType; var type = spreadsheetReport.outputType; //导出类型 logger.info(type) if (type != "refresh") { // 需要隐藏的列序号 sheet.cells.getColumndeleteColumn(3).setWidth(0); sheet.cells.getColumndeleteColumn(4).setWidth(0); } } |
- 关键对象方法
- 获取电子表格分组表sheet页:spreadsheetReport.workbook.getWorksheets().get(0)
- 获取电子表格当前输出类型:spreadsheetReport.outputType
- 设置行列宽为0:sheet.cells.getColumndeleteColumn(3).setWidth(0)