function main(spreadsheetReport) {
var cells = spreadsheetReport.workbook.worksheets.get(0).cells; //获取行值
var list = spreadsheetReport.sheets[0].getExpandedPositions("G13"); //获取的列值
logger.info(list);
if (list.length == 1) {
var value = cells.get(list[0].row, list[0].column).value; //单元格的值
if (value == null || value == "") { //单元格值判断
var row = list[0].row;
cells.hideRow(row - 1); //隐藏的开始行
cells.hideRow(row); //隐藏的结束行
}
}
}