//初始化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 = { //设定整体的线的样式
}
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 = { //设定整体的线的样式
}