jsp上传excel文件源码

<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="org.apache.poi.ss.usermodel.*" %>
<%@ page import="org.apache.poi.xssf.usermodel.*" %>

<%
    // 检查是否有文件上传
    boolean isMultipart = ServletFileUpload.isMultipartContent(request);
    if (!isMultipart) {
        out.println("No file uploaded");
        return;
    }

    // 创建文件项工厂
    DiskFileItemFactory factory = new DiskFileItemFactory();

    // 创建文件上传处理器
    ServletFileUpload upload = new ServletFileUpload(factory);

    try {
        // 解析请求，获取文件项列表
        List<FileItem> items = upload.parseRequest(request);

        // 遍历文件项
        for (FileItem item : items) {
            if (!item.isFormField()) { // 如果是文件上传项
                String fileName = item.getName();
                InputStream fileContent = item.getInputStream();

                // 使用Apache POI读取Excel文件
                Workbook workbook = new XSSFWorkbook(fileContent);
                Sheet sheet = workbook.getSheetAt(0);

                // 遍历工作表中的每一行
                for (Row row : sheet) {
                    // 遍历每一行的每一个单元格
                    for (Cell cell : row) {
                        // 根据单元格类型获取值
                        switch (cell.getCellType()) {
                            case STRING:
                                out.println(cell.getStringCellValue() + "\t");
                                break;
                            case NUMERIC:
                                out.println(cell.getNumericCellValue() + "\t");
                                break;
                            case BOOLEAN:
                                out.println(cell.getBooleanCellValue() + "\t");
                                break;
                            default:
                                out.println("Unknown cell type\t");
                        }
                    }
                    out.println("<br>");
                }

                // 关闭工作簿
                workbook.close();
            }
        }
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    }
%>