本帖最后由 牛马大队 于 2021-7-9 15:00 编辑
设置整行颜色时,隔行会被默认的主题颜色冲掉,比如想要把前5行变黑该如何设置?
- spread.suspendPaint()
- let sheet = spread.getActiveSheet()
- sheet.setColumnCount(50)
- let tableStyle = GC.Spread.Sheets.Tables.TableThemes.light1
- let table = sheet.tables.add('table1', 0, 0, 200, 50, tableStyle)
- this.table = table
- this.spread = spread
- sheet.setArray(1, 0, tableData)
- let style = new GC.Spread.Sheets.Style()
- style.locked = true
- style.backColor = '#666'
- style.foreColor = 'white'
- sheet.setStyle(0, -1, style)
- sheet.setStyle(1, -1, style)
- sheet.setStyle(2, -1, style)
- sheet.setStyle(3, -1, style)
- sheet.setStyle(4, -1, style)
- sheet.setStyle(5, -1, style)
- sheet.getRange(2, 0, 200, 50).locked(false)
- sheet.options.isProtected = true
复制代码
|
|