const spreadNS = GC.Spread.Sheets;const SHEETS = new spreadNS.Workbook(this.refs['overseas']);// set sheet count// SHEETS.setSheetCount(1);const sheet = SHEETS.sheets[0];
设置默认属性
const defaultStyle = new GC.Spread.Sheets.Style();// 设置默认背景色// @method1 defaultStyle.backColor = "LemonChiffon";// @method2 SHEETS.options.backColor = "#ccc"; //defaultStyle.foreColor = "Red";//defaultStyle.formatter = "0.00";
defaultStyle.font ="bold normal 9px normal"
defaultStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
defaultStyle.vAlign = GC.Spread.Sheets.VerticalAlign.center;//defaultStyle.borderLeft = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);//defaultStyle.borderTop = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);//defaultStyle.borderRight = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);//defaultStyle.borderBottom = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
sheet.setDefaultStyle(defaultStyle, spreadNS.SheetArea.viewport);
表格的四个部分
spreadNS.SheetArea.viewport
// spreadNS.SheetArea include the following parts// colHeader: 1 ,// corner: 0// rowHeader: 2// viewport: 3// 改变表头的背景 Set the backcolor of second row header.
sheet.getCell(1,0, GC.Spread.Sheets.SheetArea.rowHeader).backColor("Yellow");
/**
* @name set the bgColor of column
*
* @type1
* sheet.getRange(-1, 1, -1, 1).backColor("lightYellow").width(330);
*
* @name set the bgColor of row
*
* @type1
* sheet.getRange(0, -1, 1, -1).backColor("lightYellow").height(44)
*
* @type2
* const rowStyle1 = new spreadNS.Style();
* rowStyle1.backColor = "#bdcde3";
* sheet.setStyle(0, -1, rowStyle1, spreadNS.SheetArea.viewport);
*/
events
// 获取点击的cell和所在的sheet
SHEETS.bind(spreadNS.Events.EnterCell, function (event, data){
console.log(data.col)
console.log(data.row)
console.log(data)
var activeSheet = data.sheet;
activeSheet.startEdit(true);});// 离开cell事件
sheet.bind(GC.Spread.Sheets.Events.LeaveCell, function (event, infos){//Reset the backcolor of cell before moving
infos.sheet.getCell(infos.row, infos.col).backColor(undefined);});