【前端】浏览器端excel导入导出功能（ant-design-vue/element-plus, exceljs &FileReader & file-saver & web worker)

本文链接：https://blog.csdn.net/x_chengqq/article/details/136077301

参考文档：

导出：

前端性能优化之 WebWorker 优化数据导出下载 Excel 操作
 Web Worker

导入

<template>
	<a-upload
		accept=".csv,.xlsx"
		:show-upload-list="false"
		:before-upload="importFile"
	>
		<a-button>
			批量上传
		</a-button>
	</a-upload>
</template>

<script setup>
import { ref } from 'vue'
import Excel from 'exceljs'
// json格式的 excel 的数据
const tableRows = ref([])

const uploadExcelHander = (file, { header }) => {
  const excelData = []
  const buffer = new FileReader()
  buffer.onload = async function(e) {
    const result = new Uint8Array(e.target.result)
    const workbook = new Excel.Workbook()
    await workbook.xlsx.load(result)
    const worksheet = workbook.getWorksheet(1)
    worksheet.eachRow({ includeEmpty: true }, function (row, rowNumber) {
      if (rowNumber !== 1) {
        // 排除表头行
        let rowData = {}
        row.eachCell({ includeEmpty: true }, function (cell, colNumber) {
          if (colNumber < header.length) {
            const prop = header[colNumber]
            rowData[prop] = cell.value
          }
        })
        excelData.push(rowData)
      }
    })
    // callbackFn(excelData)
    tableRows.value = excelData
  }
  if (file) {
    buffer.readAsArrayBuffer(file)
  }
}

const importFile = file => {
	// 列的id
	const header = ['trading_date', 'account', 'symbol', 'vstrategy_id', 'trade_vol', 'trade_price', 'direction', 'open_close', 'daynight', 'trade_time', 'entrust_no']
	uploadExcelHander(file, { header })
}
</script>