...
代码块 |
---|
function main(spreadsheetReport) { if (spreadsheetReport.outputType != "EXCEL2007") return; spreadsheetReport.cacheable = false; var workbook = spreadsheetReport.workbook; var worksheets = workbook.worksheets; for (var i = 0; i < worksheets.count; i++) { var worksheet = worksheets.get(i); var cells = worksheet.cells; var maxDisplayRange = cells.maxDisplayRange; for (var x = 0; x < maxDisplayRange.rowCount; x++) { for (var y = 0; y < maxDisplayRange.columnCount; y++) { var cell = cells.get(x, y); if (cell.isFormula()) { cell.value = cell.value; } } } } worksheet.getCells().deleteColumn(3); //删除隐藏的列,列是从0开始计算的,即A列为第0列删除隐藏的列,行列是从0开始计算的,即A列为第0列,第一行为0 // worksheets.get("sheet名称").cells.deleteColumn(6); //如果有多个sheet,需要指定对应的sheet进行删除,sheet名称对应实际的设置的sheet名称即可 // worksheets.get("sheet名称").cells.deleteRow(30); ////如果有多个sheet,需要指定对应的sheet进行删除 } |
...