将Excel文件从React上传到C# ASP.NET核心后端

import React, { useState } from 'react';

function FileUpload() {
  const [selectedFile, setSelectedFile] = useState(null);

  const handleFileChange = (event) => {
    setSelectedFile(event.target.files[0]);
  };

  const handleUpload = () => {
    if (selectedFile) {
      const formData = new FormData();
      formData.append('file', selectedFile);

      // 使用Fetch API或Axios等库将文件上传到后端
      fetch('/api/upload', {
        method: 'POST',
        body: formData,
      })
        .then((response) => response.json())
        .then((data) => {
          // 处理上传成功后的响应
          console.log(data);
        })
        .catch((error) => {
          // 处理上传失败的错误
          console.error(error);
        });
    }
  };

  return (
    <div>
      <input type="file" onChange={handleFileChange} />
      <button onClick={handleUpload}>上传</button>
    </div>
  );
}

export default FileUpload;

using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using OfficeOpenXml;

[Route("api/[controller]")]
[ApiController]
public class UploadController : ControllerBase
{
    [HttpPost]
    public IActionResult Upload(IFormFile file)
    {
        if (file == null || file.Length <= 0)
        {
            return BadRequest("未选择文件或文件为空");
        }

        // 检查文件扩展名是否为.xlsx或.xls
        if (!Path.GetExtension(file.FileName).Equals(".xlsx", StringComparison.OrdinalIgnoreCase) &&
            !Path.GetExtension(file.FileName).Equals(".xls", StringComparison.OrdinalIgnoreCase))
        {
            return BadRequest("仅支持上传Excel文件");
        }

        try
        {
            using (var package = new ExcelPackage(file.OpenReadStream()))
            {
                // 处理Excel文件数据
                // 例如，读取工作表、解析单元格数据等

                return Ok("文件上传成功");
            }
        }
        catch (Exception ex)
        {
            return StatusCode(StatusCodes.Status500InternalServerError, $"文件上传失败：{ex.Message}");
        }
    }
}