只有复选框出来了,而且只有点击复选框之后层级才会显示
methods{ workbookInitialized(spread){ this.loadData(sheet); this.initOutlineColumn(sheet); this.setOutlineColumnOptions(sheet); sheet.resumePaint() }, loadData (sheet) { query().then(response => { var params = response.data sheet.suspendPaint() let sd = params ; sheet.setDataSource(sd); for (let r = 0; r < sd.length; r++) { let level = sd[r].level; sheet.getCell(r, 0).textIndent(level); } var colInfos = [ {name: "pdId",displayName:'序号'}, {name: "planUnique",displayName:'标识'}, {name: "equipMajorCode",displayName:'专业'}, {name: "proEqName",displayName:'名称'}, {name: "proEquipCode",displayName:'代码'}, ]; sheet.bindColumns(colInfos); } sheet.resumePaint() }) }, initOutlineColumn (sheet) { sheet.outlineColumn.options({ columnIndex: 0, showCheckBox: true, maxLevel: 3 }); sheet.showRowOutline(false); sheet.outlineColumn.refresh(); }, setOutlineColumnOptions (sheet) { let options = sheet.outlineColumn.options(); } } }
|