设置下拉:
- const combo = new spreadNS.CellTypes.ComboBox();
- combo.items(style.Itme);
- combo.editorValueType(Type);
- combo.editable(style.isEdit);
- combo.itemHeight( Number(style.height));
- for(var j = range.col; j< range.col+range.colCount; j++){
- for(var i = range.row; i< range.row+range.rowCount; i++){
- sheet.getCell(i, j, spreadNS.SheetArea.viewport).cellType(combo).value(style.Itme[0].text);
- }
- }
复制代码
导出excel文件:
- let spreadJSON = JSON.stringify(spreadInit.toJSON(jsonOptions));
- excelIO.save(spreadJSON, function (blob) {
- saveAs(blob, excelName);
- spreadInit.options.newTabVisible = false;
- spreadInit.options.tabEditable = false;
- spreadInit.options.tabNavigationVisible = false;
- spreadInit.options.tabStripVisible = false;
- resolve("导出成功");
复制代码
然后导出就显示下拉的第一个值 |