function main(spreadsheetReport) {
var cells = spreadsheetReport.workbook.worksheets.get(0).cells; //获取行值
var B4List = spreadsheetReport.sheets[0].getExpandedPositions("B4"); //获取第一个表格"是否"扩展字段扩展出来的所有单元格
// var B7List = spreadsheetReport.sheets[0].getExpandedPositions("B7");
// var B10List = spreadsheetReport.sheets[0].getExpandedPositions("B10");
for (var i = 0; i < B4List.length; i++) {
var B4 = B4List[i];
if (parseInt(cells.get(B4.row, B4.column).value) == 0) { //判断值是否为0
cells.get(B4.row - 1, B4.column + 3).value = ""; //设置"明细1"内容为空,即不显示
cells.get(B4.row, B4.column + 3).value = ""; //设置"明细2"内容为空,即不显示
}
}
// for (var i = 0; i < B7List.length; i++) {
// var B7 = B7List[i];
// if (cells.get(B7.row, B7.column).value == "0") {
// cells.get(B7.row - 1, B7.column + 3).value = "";
// cells.get(B7.row, B7.column + 3).value = "";
// }
// }
// for (var i = 0; i < B10List.length; i++) {
// var B10 = B10List[i];
// if (cells.get(B10.row, B10.column).value == "0") {
// cells.get(B10.row - 1, B10.column + 3).value = "";
// cells.get(B10.row, B10.column + 3).value = "";
// }
// }
}