éè¿styleçç¸å ³æ¥å£è¿è¡è®¾ç½®ï¼åå æ ¼çæ ·å¼é½å¨styleä¸ä¿åã
å¯ä»¥æé ä¸ä¸ªæ ·å¼å¹¶è®¾ç½®ä¸åçå±æ§ï¼ä¾å¦ï¼
var style = new GC.Spread.Sheets.Style();
style.backColor = 'red';
style.foreColor = 'green';
style.isVerticalText = 'true';
ä¹åï¼ä½ å¯ä»¥å°æ¤æ ·å¼è®¾ç½®ç»åå æ ¼, è¡, æè å:
sheet.setStyle(5, 5, style, GC.Spread.Sheets.SheetArea.viewport);
sheet.setStyle(5, -1, style, GC.Spread.Sheets.SheetArea.viewport);
sheet.setStyle(-1, 5, style, GC.Spread.Sheets.SheetArea.viewport);
æ ·å¼å¨ä¸åçå±çº§ç»æä¸å ·æä¸åçä¼å 级å«, åå æ ¼ > è¡ > åã
å¯ä»¥æé å¤ä¸ªæ ·å¼å¹¶è®¾ç½®å±æ§ï¼ç¨äºå¯¹æ¯çåºä¼å 级ï¼ä¾å¦ï¼
1.æé åå æ ¼çæ ·å¼
var cellStyle = new GC.Spread.Sheets.Style();
cellStyle.backColor = 'red';
2.æé è¡æ ·å¼
var rowStyle = new GC.Spread.Sheets.Style();
rowStyle .backColor = 'green';
3.æé åæ ·å¼
var colStyle = new GC.Spread.Sheets.Style();
colStyle.backColor = 'yellow';
4.ç»åå
æ ¼ï¼æ´è¡ï¼æ´å设置ä¸è¿°æ ·å¼ï¼
sheet.setStyle(5,5,cellStyle, GC.Spread.Sheets.SheetArea.viewport);
sheet.setStyle(5,-1,rowStyle, GC.Spread.Sheets.SheetArea.viewport);
sheet.setStyle(-1,5,colStyle, GC.Spread.Sheets.SheetArea.viewport);
sheet.setStyle(-1,6,colStyle, GC.Spread.Sheets.SheetArea.viewport);
ä¸è¿°ä»£ç æ§è¡ææå¦ä¸å¾æ示ï¼
ç±æ¤å¯è§ï¼æ ·å¼çä¼å 级ï¼åå æ ¼ > è¡ > å