vue3+ts读取excel文件数据

最新推荐文章于 2024-02-28 14:37:56 发布

yasuo56

最新推荐文章于 2024-02-28 14:37:56 发布

阅读量3k

点赞数 4

文章标签： excel vue.js typescript

本文链接：https://blog.csdn.net/yasuo56/article/details/128020622

版权

先下载xlsx依赖

npm i xlsx --save

在所需页面引入xlsx依赖

import * as xlsx from "xlsx";

必须这样写写别的引入会报错！！

先把文件读取为二进制文件

/**
 * 把文件按照二进制进行读取
 * @param file 
 * @returns 
 */
const readFile=(file:File)=>{
    return new Promise(resolve=>{
        let reader = new FileReader();
        reader.readAsBinaryString(file);
        reader.onload = ev =>{
            resolve(ev.target?.result);
        }
    });
}

封装对二进制文件的操作

/**
 * 根据sheet索引读取Excel文件中的数据
 /**@param file 文件
 /** @param sheetIndex excel文件中sheet表索引 默认是从0开始
 /**@returns  将表中的数据以json形式的数据返回
*/
const readExcelFile=async (file: File, sheetIndex: number)=>{
  let data = await readFile(file);
  let workbook = xlsx.read(data, { type: 'binary' });
  let worksheet = workbook.Sheets[workbook.SheetNames[sheetIndex]];
  data = xlsx.utils.sheet_to_json(worksheet);
  console.log(data);
  return data;
}

调用readExcelFile方法获取到数据之后接下来就可以进行页面的渲染

const before = (file:any) => {
  readExcelFile(file,0)
  return false
}

页面用的是element-plus的upload按钮

<el-upload v-model:file-list="fileList" class="upload-demo" :before-upload="before"
      action="http://run.mocky.io/v3/9d059bf9-4660-45f2-925d-ce80ad6c4d15" multiple :on-preview="handlePreview"
        :limit="3"  accept="xlsx,xls">
      <el-button type="success">上传excel</el-button>
 </el-upload>

以下是全部代码

<script lang="ts" setup>
import { ref, onMounted } from 'vue'
import * as xlsx from "xlsx";
// import XlSX from 'xlsx'
import type { UploadProps, UploadUserFile } from 'element-plus'
const fileList = ref<UploadUserFile[]>([])
const handlePreview: UploadProps['onPreview'] = (uploadFile) => {
  console.log(uploadFile)
}
/**
 * 把文件按照二进制进行读取
 * @param file 
 * @returns 
 */
const readFile=(file: File)=> {
  return new Promise(resolve => {
    let reader = new FileReader();
    reader.readAsBinaryString(file);
    reader.onload = ev => {
      resolve(ev.target?.result);
    }
    console.log(reader);

  });
}
/**
 * 根据sheet索引读取Excel文件中的数据
 /**@param file 文件
 /** @param sheetIndex excel文件中sheet表索引 默认是从0开始
 /**@returns  将表中的数据以json形式的数据返回
*/
const readExcelFile=async (file: File, sheetIndex: number)=>{
  let data = await readFile(file);
  let workbook = xlsx.read(data, { type: 'binary' });
  let worksheet = workbook.Sheets[workbook.SheetNames[sheetIndex]];
  data = xlsx.utils.sheet_to_json(worksheet);
  console.log(data);
  return data;
}
const before = (file:any) => {
  readExcelFile(file,0)
  return false
}
</script>
<template>
  <div>
    <el-upload v-model:file-list="fileList" class="upload-demo" :before-upload="before"
      action="http://run.mocky.io/v3/9d059bf9-4660-45f2-925d-ce80ad6c4d15" multiple :on-preview="handlePreview"
        :limit="3"  accept="xlsx,xls">
      <el-button type="success">上传excel</el-button>
    </el-upload>
  </div>
</template>

<style>

</style>