从Restful后端java读取上传的xlsx文件

Question

我正在通过ajax-post调用从UI上传excel文件，并试图从支持的Restful服务java代码中读取该文件，但我无法正确打印excel文件内容。文件名和其他属性打印正确。

[java] org.jboss.resteasy.spi.UnhandledException: org.jboss.resteasy.core.ExceptionAdapter:  : null

public Response upload(final MultipartFormDataInput input)throws Exception{
    for (InputPart part : input.getParts()) { // you might get multiple files
        final String disposition = part.getHeaders().getFirst("Content-Disposition");
        final String fileName =  disposition.replaceFirst("(?i)^.*filename=\"([^\"]+)\".*$", "$1");
        InputStream inputStream = part.getBody(FileInputStream.class, null);
        try {
            Workbook workbook = WorkbookFactory.create(inputStream);
            Sheet datatypeSheet = workbook.getSheetAt(0);
            Iterator<Row> iterator = datatypeSheet.iterator();

            while (iterator.hasNext()) {
                Row currentRow = iterator.next();
                Iterator<Cell> cellIterator = currentRow.iterator();

                while (cellIterator.hasNext()) {

                    Cell currentCell = cellIterator.next();
                    if (currentCell.getCellType() == Cell.CELL_TYPE_STRING) {
                        System.out.print(currentCell.getStringCellValue() + "--");
                    } else if (currentCell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
                        System.out.print(currentCell.getNumericCellValue() + "--");
                    } else if(currentCell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
                        System.out.print(currentCell.getBooleanCellValue() + "--");
                    } else {
                        System.out.print("<BLANK>--");
                    }
                }
                System.out.println();
            }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    input.close();
    return Response.ok("OK").build();
}

 [java] Caused by: java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

Answer 1

我发现我们需要将excel流作为

File.class而不是InputStream.class

public Response upload(final MultipartFormDataInput input)throws Exception{
    Map<String, List<InputPart>> formDataMap = input.getFormDataMap();
    File inputStream = formDataMap.get("files").get(0).getBody(File.class, null);
    String extraField = formDataMap.get("extraField").get(0).getBodyAsString();
    String CustomField =  formDataMap.get("CustomField").get(0).getBodyAsString();

    try {

        Workbook workbook = WorkbookFactory.create(inputStream);
        Sheet datatypeSheet = workbook.getSheetAt(0);
        Iterator<Row> iterator = datatypeSheet.iterator();

        while (iterator.hasNext()) {

            Row currentRow = iterator.next();
            Iterator<Cell> cellIterator = currentRow.iterator();

            while (cellIterator.hasNext()) {
                Cell currentCell = cellIterator.next();

                if (currentCell.getCellType() == Cell.CELL_TYPE_STRING) {
                    System.out.print(currentCell.getStringCellValue() + "--");
                } else if (currentCell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
                    System.out.print(currentCell.getNumericCellValue() + "--");
                } else if(currentCell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
                    System.out.print(currentCell.getBooleanCellValue() + "--");
                } else {
                    System.out.print("<BLANK>--");
                }
            }
            System.out.println();

        }
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }


    input.close();
    return Response.ok("OK").build();
}