Comment implémenter le filtrage multi-conditions des données de table via Vue et Excel

<template>
  <div>
    <input type="file" @change="handleFileUpload" />
    <table>
      <tr v-for="(row, index) in filteredData" :key="index">
        <td v-for="(cell, cellIndex) in row" :key="cellIndex">
          {{ cell }}
        </td>
      </tr>
    </table>
  </div>
</template>

<script>
import { parse } from "papaparse";

export default {
  data() {
    return {
      fileData: [],
      filteredData: []
    };
  },
  methods: {
    handleFileUpload(e) {
      const file = e.target.files[0];
      parse(file, {
        complete: (results) => {
          this.fileData = results.data;
          this.filterData();
        }
      });
    },
    filterData() {
      // Add your filtering logic here
      // You can use this.fileData to access the original data
      // Set the filtered data to this.filteredData
    }
  }
};
</script>

<template>
  <div>
    <input type="file" @change="handleFileUpload" />
    <input type="text" v-model="searchKeyword" placeholder="请输入关键词" />
    <button @click="filterData">搜索</button>
    <table>
      <tr v-for="(row, index) in filteredData" :key="index">
        <td v-for="(cell, cellIndex) in row" :key="cellIndex">
          {{ cell }}
        </td>
      </tr>
    </table>
  </div>
</template>

<script>
import { parse } from "papaparse";

export default {
  data() {
    return {
      fileData: [],
      filteredData: [],
      searchKeyword: ""
    };
  },
  methods: {
    handleFileUpload(e) {
      const file = e.target.files[0];
      parse(file, {
        complete: (results) => {
          this.fileData = results.data;
          this.filterData();
        }
      });
    },
    filterData() {
      if (!this.searchKeyword) {
        this.filteredData = this.fileData;
        return;
      }
      this.filteredData = this.fileData.filter((row) => {
        return row.some((cell) => {
          return cell.toString().toLowerCase().includes(this.searchKeyword.toLowerCase());
        });
      });
    }
  }
};
</script>