- <head>
- <meta charset="UTF-8" />
- <link
- rel="stylesheet" type="text/css" />
- <script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/gc.spread.sheets.all.14.1.5.min.js"></script>
- <script src="http://cdn.grapecity.com/spreadjs/hosted/scripts/interop/gc.spread.excelio.14.1.5.min.js"></script>
- <script src="https://cdn.grapecity.com.cn/spreadjs/scripts/jquery-1.11.1.min.js" type="text/javascript"></script>
- <style>
- .sample-tutorial {
- position: relative;
- height: 100%;
- overflow: hidden;
- }
- .sample-spreadsheets {
- width: calc(100% - 280px);
- height: 90%;
- overflow: hidden;
- float: left;
- position: relative;
- }
- .gc-drop-down-list {
- background: red;
- }
- </style>
- </head>
- <body>
- <div id="ss" class="sample-spreadsheets"></div>
- <script>
- var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), {
- sheetCount: 1
- });
- var sheet = spread.getActiveSheet();
- /**
- 数据都是从后台获取的,不是很好复现
- data:[{
- row:1,
- col:1
- },{
- row:1,
- col:1
- },{
- row:3,
- col:1
- }]
- 首先:刷新页面的时候,后端返回的数据如果excel中存在,就将excel中有此数据的单元格的背景色设置成绿色
- 如果后端返回第一项的数据和第二项的数据一样,就将excel相应位置的背景色设置成红色
- */
- // 1.将row:1,row:2这两列设置成红色
- var style = new GC.Spread.Sheets.Style();
- style.backColor = 'red';
- // style.backColor = 'blue';
- sheet.setStyle(1, 1, style, GC.Spread.Sheets.SheetArea.viewport);
- sheet.setStyle(3, 1, style, GC.Spread.Sheets.SheetArea.viewport);
- //2.由于row:1存在重复数据,所以需要将row:1,这项单元格再设置成其他颜色
- // sheet.setStyle(1, 1, style.backColor = 'blue', GC.Spread.Sheets.SheetArea.viewport);
- </script>
- </body>
- </html>
复制代码 |