我页面上的表格列头是可以拖动调整列宽的,但是我导出后打开的excel文件,列头不能拖动,这是什么原因呢?我打印看了- workbook?.toJSON({columnHeadersAsFrozenRows: false, includeBindingSource: false})
复制代码
属性也设置没问题啊
- const excelIO = new IO()
- let obj = Utility.cloneDeepNew(workbook?.toJSON({columnHeadersAsFrozenRows: false, includeBindingSource: false}))
- const {sheets} = obj
- sheets.Sheet1.rowFilter = [] // 删除过滤配置,导出全部数据
- const json = JSON.stringify(obj)
- console.log("导出", obj)
- excelIO.save(
- json,
- (blob: Blob) => {
- const url = URL.createObjectURL(blob)
- const link = document.createElement("a")
- link.href = url
- link.download = `${name}.xlsx`
- link.style.display = "none"
- document.body.appendChild(link)
- link.click()
- document.body.removeChild(link)
- },
- (error: {errorCode: IO.ErrorCode; errorMessage: string}) => {
- UI.info(`${error.errorCode}: ${error.errorMessage}`)
- }
- )
复制代码 我导出也没干什么啊。。。
|