复制

    let yourElement = document.getElementById("yourElement");
    let wsheet = new websheet('HTML', yourElement,0,0,800,400);

    /**
    * 第一步 获取激活的sheet
    */
 
   let activeSheet = wsheet.ActiveSheet();
 
 
   /**
    * 隶书
    */
   let newFontls = new websheet.Model.Font();
   newFontls.name = '隶书';
   newFontls.sz = 18;
   newFontls.color.rgb = '#FFFFFF';
 
   activeSheet.SetCellFont('C2', newFontls);
 
   activeSheet.setRowHeight(2, 22);
 
 
   let tableColumn = [];
   let col = 1;
   tableColumn.push('测试' + (col++) + '列');
   tableColumn.push('测试' + (col++) + '列');
   tableColumn.push('测试' + (col++) + '列');
   tableColumn.push('测试' + (col++) + '列');
 
 
 
   activeSheet.addTable('测试1', 'C2:L12', tableColumn, 'TableStyleMedium2');
 
 
   let i = 3;
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   activeSheet.SetCellValue(3, i, i++);
   let r = 3;
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
   activeSheet.SetCellValue(r, 3, r++);
  
   activeSheet.SetCellValue(13, 11, '总计：');
 
   activeSheet.SetCellValue(13, 12, '=SUM(C3:C12)');
 
   activeSheet.WorkFormula(); //重建公式
   activeSheet.cacl();//公式计算
 
   wsheet.BuildSheet();
   wsheet.Draw();
 
 
   // activeSheet.DelTable('测试1');
 
   // wsheet.BuildSheet();
   // wsheet.Draw();