spreadJS注释功能码

女爷i 2022-05-30 08:09 224阅读 0赞

//初始化spread  
    function initSpread(spread)  
    \{  
        var sheet = spread.getActiveSheet();  
        sheet.setColumnCount(4);  
        sheet.setRowCount(6);  
        //sheet.Range(0,0,6,6).HAlignment = 2;        
        //合并区域  
        sheet.addSpan(0, 0, 1, 4);  
        sheet.addSpan(3, 0, 1, 4);  
          
          
        //设置特定区域背景色  
        sheet.getRange(0, )  
        sheet.getRange(0, 0, 1, 1).backColor("\#D9D9FF");  
        sheet.getRange(0, 0, 6, 3).hAlign(GC.Spread.Sheets.HorizontalAlign.center);//设定区域对齐方式  
        sheet.getRange(3, 0, 1, 1).backColor("\#D9D9FF");  
  
  
        //设定列宽  
        sheet.setColumnWidth(1, 120);  
        sheet.setColumnWidth(2, 120);  
        sheet.setColumnWidth(3, 120);  
        sheet.setColumnWidth(0, 120);  
  
        //设定特定单元格值  
        sheet.setValue(0, 0, "粒度分布");  
        sheet.setValue(3, 0, "粒度分布(高速剪切)");  
        sheet.setValue(1, 0, "d10");  
        sheet.setValue(1, 1, "d50");  
        sheet.setValue(1, 2, "d90");  
        sheet.setValue(1, 3, "d99");  
        sheet.setValue(4, 0, "d10");  
        sheet.setValue(4, 1, "d50");  
        sheet.setValue(4, 2, "d90");  
        sheet.setValue(4, 3, "d99");  
  
  
  
          
        //设置spread的边框为实体线  
        var spreadNS = GC.Spread.Sheets;  
        sheet.getRange(0, 0, 6, 4).setBorder(new spreadNS.LineBorder("Black", spreadNS.LineStyle.thin), \{ all: true \});  
        //sheet.options.gridline = \{   //设定整体的线的样式  
    
  
    \}