如何使用HTML输入文件导入excel文件并在Node.js中读取文件内容(如何向Node.js发送完整路径)

<input type="file" id="fileInput" onchange="handleFile(this.files)">

function handleFile(files) {
  if (files.length === 0) return;

  const file = files[0];
  const formData = new FormData();
  formData.append("file", file);

  fetch("/upload", {
    method: "POST",
    body: formData,
  })
    .then(response => response.json())
    .then(data => {
      console.log(data); // 处理服务器返回的数据
    })
    .catch(error => {
      console.error(error);
    });
}

npm install multer

const express = require("express");
const multer = require("multer");

const app = express();
const upload = multer({ dest: "uploads/" }); // 指定上传文件保存的目录

app.post("/upload", upload.single("file"), (req, res) => {
  const filePath = req.file.path; // 获取保存在服务器上的文件路径
  // 处理Excel文件内容，如使用第三方库`exceljs`解析Excel
  // 示例代码：
  // const workbook = new Excel.Workbook();
  // workbook.xlsx.readFile(filePath)
  //   .then(worksheet => {
  //     // 处理Excel文件内容
  //     res.json({ success: true, message: "File uploaded and processed successfully." });
  //   })
  //   .catch(error => {
  //     console.error(error);
  //     res.json({ success: false, message: "Failed to process the uploaded file." });
  //   });
});

app.listen(3000, () => {
  console.log("Server is running on port 3000");
});