...
代码块 | ||
---|---|---|
| ||
function main(spreadsheetReport) {
if (spreadsheetReport.outputType != "EXCEL2007") return;
spreadsheetReport.cacheable = false;
var workbook = spreadsheetReport.workbook;
var worksheet = workbook.worksheets.get(0);
worksheet.getCells().deleteColumn(0); //删除隐藏的列
} |
注:如果隐藏的列有被其它单元格引用,可以使用下面的报表宏实现导出删除。
代码块 |
---|
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); //删除隐藏的列
}
|
注:针对清单报表,输出类型是“LIST_EXCEL”,可直接将上面的代码中的“EXCEL2007”修改为“LIST_EXCEL”即可执行,如图:
...