function main(pageServer: IPageServer, portletServer: ITableSheetPortletServer) {
let sheet = portletServer.getSheetByName("Sheet2");
let positions = "E3".split(",");
for (let i = 0; i < positions.length; i++) {
let position = positions[i].trim();
let expandedPositions = sheet.getExpandedPositions(position);
for (let j = 0; j < expandedPositions.length; j++) {
let cell = sheet.getCell(expandedPositions[j]);
if (true) {
addLink(portletServer, sheet, cell);
}
}
}
}
function addLink(portletServer: ITableSheetPortletServer,
sheet: ISheetServer, cell: ISheetCellServer) {
sheet.addRuleLink(cell.getCellPosition(), "明细_添加跳转规则",
[getCellValue(cell.getRelativeCells("B3")), getCellValue(cell.getRelativeCells("C3"))]);
}
function getCellValue(cell: any) {
if (!cell) return null;
if (typeof cell.length == 'number') {
var ret = [];
for (var i = 0; i < cell.length; i++) {
if(cell[i]!=null)
ret.push(cell[i].value);
}
return ret;
} else {
return cell.value;
}
}