1.前端进行excel的导出
//输出函数
output(){
//excel头部
const tHeader=[]
//excel对应的字段
const filterVal = []
//需要带出的数据
let excelList = tableData
//导出的文件名
const filname = ''
const data = this.formatJson(filterVal,excelList)
export_json_to_excel({
header:tHeader,
data,
filename
})
}
//对每一项进行处理
formatJson(filterVal,excelList){
let i
return excelList.map((v)=>{
filterVal.map(j=>{
}
}
export_json_to_excel文件
import XLSX from 'xlsx'
import fileSaver from 'file-saver'
export function export_json_to_excel({
header,
data,
filename,
autoWidth = true,
bookType = 'xlsx'
} = {}) {
/* original data */
filename = filename || 'excel-list'
data = [...data]
data.unshift(header)
var ws_name = 'SheetJS'
var wb = new Workbook()
var ws = sheet_from_array_of_arrays(data)
if (autoWidth) {
/* 设置worksheet每列的最大宽度*/
const colWidth = data.map((row) =>
row.map((val) => {
/* 先判断是否为null/undefined*/
if (val == null) {
return {
wch: 10
}
} else if (val.toString().charCodeAt(0) > 255) {
/* 再判断是否为中文*/
return {
wch: val.toString().length * 2
}
} else {
return {
wch: val.toString().length
}
}
})
)
/* 以第一行为初始值*/
const result = colWidth[0]
for (let i = 1; i < colWidth.length; i++) {
for (let j = 0; j < colWidth[i].length; j++) {
if (result[j]['wch'] < colWidth[i][j]['wch']) {
result[j]['wch'] = colWidth[i][j]['wch']
}
}
}
ws['!cols'] = result
}
/* add worksheet to workbook */
wb.SheetNames.push(ws_name)
wb.Sheets[ws_name] = ws
var wbout = XLSX.write(wb, {
bookType: bookType,
bookSST: false,
type: 'binary'
})
saveAs(
new Blob([s2ab(wbout)], {
type: 'application/octet-stream'
}),
`${filename}.${bookType}`
)
}
function sheet_from_array_of_arrays(data, opts) {
var ws = {}
var range = {
s: {
c: 10000000,
r: 10000000
},
e: {
c: 0,
r: 0
}
}
for (var R = 0; R != data.length; ++R) {
for (var C = 0; C != data[R].length; ++C) {
if (range.s.r > R) range.s.r = R
if (range.s.c > C) range.s.c = C
if (range.e.r < R) range.e.r = R
if (range.e.c < C) range.e.c = C
var cell = {
v: data[R][C]
}
if (cell.v == null) continue
var cell_ref = XLSX.utils.encode_cell({
c: C,
r: R
})
if (typeof cell.v === 'number') cell.t = 'n'
else if (typeof cell.v === 'boolean') cell.t = 'b'
else if (cell.v instanceof Date) {
cell.t = 'n'
cell.z = XLSX.SSF._table[14]
cell.v = datenum(cell.v)
} else cell.t = 's'
ws[cell_ref] = cell
}
}
if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range)
return ws
}
class Workbook {
constructor() {
if (!(this instanceof Workbook)) { return new Workbook() }
this.SheetNames = []
this.Sheets = {}
}
}
function s2ab(s) {
var buf = new ArrayBuffer(s.length)
var view = new Uint8Array(buf)
for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF
return buf
}
2.切换页面时el-button的disabled会失效
//加入key
<el-button disabled key="value"></el-button>
3.在传递表单数据中,修改图片不发生变化,更改其他选项图片才会发生变化
原因:双向绑定的更新机制问题解决:手动获取结构赋值
4.上传带图片文件的参数给后端
uploadFile(){
const formData = new FormData()
//将所有后端需要的参数都通过formData传递给后端
formData.append('file',this.file)
formData.append('state',this.state)
formData.append('isUse',this.isUse)
}
5input formData文件上传,同一文件不能二次上传问题