表格列可见权限控制

let colsInfo = []                 //所有列
let tempInfo = []               //临时列

function generateCol(empCol){
    let column1 = new GC.Spread.Sheets.Tables.TableColumn(1,'orderDate','订单日期')
    empCol.push(column1)

    let column2 = new GC.Spread.Sheets.Tables.TableColumn(2,'item','明细',)
    empCol.push(column2)
   
    let column3 = new GC.Spread.Sheets.Tables.TableColumn(3,'cost','金额','$#,##0.00')
    empCol.push(column3)
 
    let checkBox = new GC.Spread.Sheets.CellTypes.CheckBox()
    checkBox.textTrue('是')
    checkBox.textFalse('否')
    let column4 = new GC.Spread.Sheets.Tables.TableColumn(4,'isCash','是否现金',null,checkBox,'isCash')
    empCol.push(column4)
    
    return empCol
}

colsInfo = generateCol(colsInfo)
tempInfo = generateCol(tempInfo)

let table = sheet.tables.add('table01',1,1,4,4,GC.Spread.Sheets.Tables.TableThemes.light1)；
table.bindColumns(colsInfo)

spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (s, e) {
  let { row, col, sheet } = e;
  let deleteCol = sheet.getCell(row, col).value();
  sheet.suspendPaint();
  if (deleteCol !== "reset") {
    let index = findColIndex(deleteCol);
    if (index > -1) {
      tempInfo.splice(index, 1);
      let table = sheet.tables.findByName("table01");
      let range = table.range();
      sheet.tables.remove(table);
      let newTable = sheet.tables.add(
        "table01",
        range.row,
        range.col,
        range.rowCount,
        tempInfo.length,
        GC.Spread.Sheets.Tables.TableThemes.light1
      );
      newTable.bindColumns(tempInfo);
    }
  } else {
    let table = sheet.tables.findByName("table01");
    let range = table.range();
    sheet.tables.remove(table);
    let newTable = sheet.tables.add(
      "table01",
      range.row,
      range.col,
      range.rowCount,
      colsInfo.length,
      GC.Spread.Sheets.Tables.TableThemes.light1
    );
    newTable.bindColumns(colsInfo);
    tempInfo = generateCol([]);
  }
  sheet.resumePaint();
});

function findColIndex(deleteCol) {
  let index = -1;
  for (let i = 0; i < tempInfo.length; i++) {
    if (tempInfo[i].dataField() == deleteCol) {
      return i;
    }
  }
  return index;
}