复制

 
    let yourElement = document.getElementById("yourElement");
    let wsheet = new websheet('HTML', yourElement,0,0,800,400);
 
    /**
    * 第一步 获取激活的sheet，和已经掌握内容
    */
   let activeSheet = wsheet.ActiveSheet();
   activeSheet.SetCellValue('B2', 'leftTop');
   activeSheet.SetCellValue('C2', 'leftCenter');
   activeSheet.SetCellValue('D2', 'leftBottom');
   activeSheet.SetCellValue('B3', 'CenterTop');
   activeSheet.SetCellValue('C3', 'CenterCenter');
   activeSheet.SetCellValue('D3', 'CenterBottom');
   activeSheet.SetCellValue('B4', 'rightTop');
   activeSheet.SetCellValue('C4', 'rightCenter');
   activeSheet.SetCellValue('D4', 'rightBottom');
   /**
   * 第二步    
   */
   let leftTop = new websheet.Model.CellAlignment();
   leftTop.horizontal = 'left'; //垂直方面
   leftTop.vertical = 'top';//水平方向
   activeSheet.SetCellAlignment('B2', leftTop);
 
   let leftCenter = new websheet.Model.CellAlignment();
   leftCenter.horizontal = 'left';//垂直方面
   leftCenter.vertical = 'center';//水平方向
   activeSheet.SetCellAlignment(2,3,leftCenter); // 
 
   let leftbottom = new websheet.Model.CellAlignment();
   leftbottom.horizontal = 'left';//垂直方面
   leftbottom.vertical = 'bottom';//水平方向
   activeSheet.SetCellAlignment('D2', leftbottom); // 
 
   let centerTop = new websheet.Model.CellAlignment();
   centerTop.horizontal = 'center'; //垂直方面
   centerTop.vertical = 'top';//水平方向
   activeSheet.SetCellAlignment('B3', centerTop);
 
   let centeCenter = new websheet.Model.CellAlignment();
   centeCenter.horizontal = 'center';//垂直方面
   centeCenter.vertical = 'center';//水平方向
   activeSheet.SetCellAlignment('C3', centeCenter); // 
 
   let centerbottom = new websheet.Model.CellAlignment();
   centerbottom.horizontal = 'center';//垂直方面
   centerbottom.vertical = 'bottom';//水平方向
   activeSheet.SetCellAlignment('D3', centerbottom); 
 
   let rightTop = new websheet.Model.CellAlignment();
   rightTop.horizontal = 'right'; //垂直方面
   rightTop.vertical = 'top';//水平方向
   activeSheet.SetCellAlignment('B4', rightTop);
 
   let rightCenter = new websheet.Model.CellAlignment();
   rightCenter.horizontal = 'right';//垂直方面
   rightCenter.vertical = 'center';//水平方向
   activeSheet.SetCellAlignment('C4', rightCenter); 
 
   let rightbottom = new websheet.Model.CellAlignment();
   rightbottom.horizontal = 'right';//垂直方面
   rightbottom.vertical = 'bottom';//水平方向
   activeSheet.SetCellAlignment('D4', rightbottom); 
 
   //先忽略这里 这里设置行列的高度和宽度
   activeSheet.setRowHeight(4, 50);
   activeSheet.setRowHeight(2, 50);
   activeSheet.setRowHeight(3, 50);
   activeSheet.setColWidth(1, 160);
   activeSheet.setColWidth(2, 160);
   activeSheet.setColWidth(3, 160);
   activeSheet.setColWidth(4, 160);
   activeSheet.setColWidth(5, 160);
   activeSheet.setColWidth(6, 160);
 
 
   /**
    * 第三步   重新绘制表格
    */
 
   wsheet.BuildSheet();
   wsheet.Draw();