本帖最后由 qunma 于 2020-8-13 20:13 编辑
let ex = new ExcelIO.IO()
var json = this.spread.toJSON({ includeBindingSource: true,columnHeadersAsFrozenRows:true });
const that = this
ex.save(json, function (blob) {
saveAs(blob, `${Date.now()}.xlsx`);// eslint-disable-line
}, function (e) {
// process error
console.log(e);
that.$Message.error("导出失败。")
});
下面是json
{"version":"13.2.0","sheetCount":3,"allowUserZoom":false,"tabStripVisible":false,"tabStripRatio":0.7,"allowExtendPasteRange":true,"copyPasteHeaderOptions":0,"customList":[],"sheets":{"工作表1":{"name":"工作表1","isSelected":true,"activeRow":4,"activeCol":2,"theme":"Office","data":{"dataTable":{"4":{"1":{"value":111111}},"5":{"1":{"value":111112,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"6":{"1":{"value":111113,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"7":{"1":{"value":111114,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"8":{"1":{"value":111115,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"9":{"1":{"value":111116,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"10":{"1":{"value":111117,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"11":{"1":{"value":111118,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"12":{"1":{"value":111119,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"13":{"1":{"value":111120,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"14":{"1":{"value":111121,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"15":{"1":{"value":111122,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"16":{"1":{"value":111123,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"17":{"1":{"value":111124,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"18":{"1":{"value":111125,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}},"19":{"1":{"value":111126,"style":{"hAlign":3,"vAlign":1,"font":"13.3333px Calibri","imeMode":1}}}},"defaultDataNode":{"style":{"vAlign":1,"font":"13.3333px Calibri","cellType":{"info":{"h":17,"w":59}}}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rows":[null,null,null,null,{"size":19}],"rowHeaderColInfos":[{"size":40}],"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":4,"rowCount":1,"col":2,"colCount":1},"length":1},"cellStates":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"printInfo":{"paperSize":{"width":850,"height":1100,"kind":1}},"frozenlineColor":"rgba(89, 89, 89, 0.4)","sheetTabColor":"f7f7f7","protectionOptions":{"allowResizeColumns":true,"allowResizeRows":true},"index":0},"工作表2":{"name":"工作表2","isSelected":false,"theme":"Office","data":{"defaultDataNode":{"style":{"vAlign":1,"font":"13.3333px Calibri"}},"dataTable":{}},"rowHeaderData":{},"colHeaderData":{},"rowHeaderColInfos":[{"size":40}],"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"cellStates":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"frozenlineColor":"rgba(89, 89, 89, 0.4)","sheetTabColor":"f7f7f7","protectionOptions":{"allowResizeColumns":true,"allowResizeRows":true},"index":1},"工作表3":{"name":"工作表3","isSelected":false,"theme":"Office","data":{"defaultDataNode":{"style":{"vAlign":1,"font":"13.3333px Calibri"}},"dataTable":{}},"rowHeaderData":{},"colHeaderData":{},"rowHeaderColInfos":[{"size":40}],"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"cellStates":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"frozenlineColor":"rgba(89, 89, 89, 0.4)","sheetTabColor":"f7f7f7","protectionOptions":{"allowResizeColumns":true,"allowResizeRows":true},"index":2}}} |
-
|