- function changeCheckBox(row,col){
- <div> var sheet = spread.getActiveSheet();
- var cellType = sheet.getCellType(row, col);
- if(cellType instanceof GC.Spread.Sheets.CellTypes.CheckBox){
- debugger
- console.log('判断为checkBox',row,col);
- var val = sheet.getValue(row,col);
- let text = val ? '☑' : '☐'
- console.log(text);
- sheet.setValue(row,col,text);
- }
- }</div>
复制代码
- <div>/**
- * 导出功能
- */
- function spreadExport(){
- var originJson = spread.toJSON();
- changeCheckBox(0,0);
- changeCheckBox(1,0);
- changeCheckBox(0,1);
- // 文件名
- let fileName= 'demo.xlsx';
- var json = JSON.stringify(spread.toJSON());
- excelIo.save(json, function (blob) {
- saveAs(blob, fileName);
- spread.fromJSON(originJson);
- }, function (e) {
- console.log(e);
- });
- }</div>
复制代码
|