xlsx解析excel数据，解析出来的列名和在表格中看到的不同，这是怎么做到的？需要在excel中做格外的设置吗？-灵析社区

xlsx解析excel数据，解析出来的列名和在表格中看到的不同，这是怎么做到的？需要在excel中做格外的设置吗？ 下面是一段从excel中提取数据的代码 export default { props: { beforeUpload: Function, // eslint-disable-line onSuccess: Function// eslint-disable-line }, data() { return { loading: false, excelData: { header: null, results: null } } }, methods: { generateData({header, results}) { this.excelData.header = header this.excelData.results = results this.onSuccess && this.onSuccess(this.excelData) }, handleDrop(e) { e.stopPropagation() e.preventDefault() if (this.loading) return const files = e.dataTransfer.files if (files.length !== 1) { this.$message.error('Only support uploading one file!') return } const rawFile = files[0] // only use files[0] if (!this.isExcel(rawFile)) { this.$message.error('Only supports upload .xlsx, .xls, .csv suffix files') return false } this.upload(rawFile) e.stopPropagation() e.preventDefault() }, handleDragover(e) { e.stopPropagation() e.preventDefault() e.dataTransfer.dropEffect = 'copy' }, handleUpload() { this.$refs['excel-upload-input'].click() }, handleClick(e) { const files = e.target.files const rawFile = files[0] // only use files[0] if (!rawFile) return this.upload(rawFile) }, upload(rawFile) { this.$refs['excel-upload-input'].value = null // fix can't select the same excel if (!this.beforeUpload) { this.readerData(rawFile) return } const before = this.beforeUpload(rawFile) if (before) { this.readerData(rawFile) } }, readerData(rawFile) { this.loading = true return new Promise(resolve => { const reader = new FileReader() reader.onload = e => { const data = e.target.result const workbook = XLSX.read(data, {type: 'array'}) const firstSheetName = workbook.SheetNames[0] const worksheet = workbook.Sheets[firstSheetName] const header = this.getHeaderRow(worksheet) console.log("headers: ", header) const results = XLSX.utils.sheet_to_json(worksheet).filter((val, index) => { return index !== 0; })//干掉第一条 this.generateData({header, results}) this.loading = false resolve() } reader.readAsArrayBuffer(rawFile) }) }, getHeaderRow(sheet) { const headers = [] const range = XLSX.utils.decode_range(sheet['!ref']) let C const R = range.s.r /* start in the first row */ for (C = range.s.c; C 解析这样的excel  打印`this.excelData.results`。这里的`dwmc`..是从哪来的？我猜测应该是在excel中设置的。其中的`__EMPTY`..是我在原本的excel上自己添加的列表解析得到的结果。