页面历史

function main(spreadsheetReport) {
    var sheet = spreadsheetReport.sheets[0];
    var posList = sheet.getExpandedPositions("D3");//获取显示值；
    var posList2 = sheet.getExpandedPositions("C3");//获取真实值；
    var customProperties = spreadsheetReport.customProperties;
    for (var i = 0; i < posList.length; i++) {
        var pos = posList[i];
        var pos2 = posList2[i];
        var value1 = sheet.getCellValue(pos);
        var value2 = sheet.getCellValue(pos2);
        logger.info("value1: " + value1 + "   value2: " + value2);
        customProperties.put(value1, value2);
    }
}