【web电子表格】根据条件隐藏

function main(pageServer: IPageServer, portletServer: ITableSheetPortletServer) {
    let cells = portletServer.getWorkbook().getWorksheets().get(0).getCells(); //获取行值
    let list = portletServer.getSheets()[0].getExpandedPositions("G14"); //获取的列值

    var hideRowCount = 0;
    for (var i = 0; i < list.length; i++) {
        let position = list[i];
        let value = cells.get(position.getRow(), position.getColumn()).getValue();
        if (value == null || value == "") {
            cells.hideRow(position.getRow());
            hideRowCount++;
        }
    }
    // 数据全部被隐藏时，隐藏标题
    if (hideRowCount > 0 && hideRowCount == list.length) {
        cells.hideRow(list[0].getRow() - 1);
    }
}