How to export and import table data in Vue

How to export and import table data in Vue requires specific code examples

In web projects developed using Vue, we often encounter the need to import table data Export to Excel or import Excel files on demand. This article will introduce how to use Vue to implement the export and import functions of table data, and provide specific code examples.

1. Export of table data

1. Installation dependencies

First, we need to install some dependencies for exporting Excel files. Run the following command in the command line in the Vue project:

npm install file-saver xlsx --save

2. Create an export button

In the Vue component, we need to create an export button to trigger the export operate. You can add a button element to the template and bind the click event to an export method. The example is as follows:

3. Define the export method

## in the Vue component In #methods, define an export method. This method will get the data from the table and convert the data into an Excel file and export it. The specific code is as follows:

import { saveAs } from 'file-saver'
import XLSX from 'xlsx'

export default {
  methods: {
    exportData() {
      // 从表格中获取数据，假设数据存储在一个名为tableData的数组中
      const data = this.tableData

      // 创建一个工作簿对象
      const workbook = XLSX.utils.book_new()

      // 创建一个工作表对象
      const worksheet = XLSX.utils.json_to_sheet(data)

      // 将工作表添加到工作簿
      XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1')

      // 将工作簿转换为二进制数据
      const excelData = XLSX.write(workbook, { type: 'array' })

      // 将二进制数据转换为Blob对象
      const blob = new Blob([excelData], { type: 'application/octet-stream' })

      // 使用FileSaver.js保存文件
      saveAs(blob, 'table_data.xlsx')
    }
  }
}

Complete the export function

exportData method will be triggered to obtain the data from the table, convert it to an Excel file, and export it.

Create an import button

Implementing the interaction of file input

methods, the interaction of opening the file input box is implemented. The specific code is as follows:

export default {
  methods: {
    openFileInput() {
      // 触发input元素的点击事件
      this.$refs.fileInput.click()
    },
    importData() {
      const file = this.$refs.fileInput.files[0]

      // 使用FileReader读取文件内容
      const reader = new FileReader()
      reader.onload = (e) => {
        const data = new Uint8Array(e.target.result)
        const workbook = XLSX.read(data, { type: 'array' })
        const worksheet = workbook.Sheets[workbook.SheetNames[0]]
        const jsonData = XLSX.utils.sheet_to_json(worksheet, { header: 1 })

        // 处理导入的数据
        // ...
      }
      reader.readAsArrayBuffer(file)
    }
  }
}

Processing imported data

importData method, we use FileReader to read the import Excel file and parse the file contents into JSON objects. Next, we can process the imported data, such as storing it into a Vue data object, or performing other operations on the data.

importData method will be triggered. After opening the file input box and selecting the Excel file, the file content will be read and parsed into a JSON object, thereby realizing the import function.

The above is the detailed content of How to export and import table data in Vue. For more information, please follow other related articles on the PHP Chinese website!