如何在Java Apache POI中修复NotOfficeXmlFileException?

问题描述

我正在尝试创建一个仅包含"hello"的新excel文件.这是我的代码:

I'm trying to create a new excel file with just "hello" in it.Here's my code:

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFileChooser;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author kamal
 */
public class JavaApplication4 {
    private static String dir = "";
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        try {
            // TODO code application logic here
            JFileChooser jc = new JFileChooser();
                        jc.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY);
            int output = jc.showOpenDialog(null);
            if(output == JFileChooser.APPROVE_OPTION){
                File f = jc.getSelectedFile();
                String directory = f.getAbsolutePath();
                setDir(directory);
            }


            FileOutputStream out = new FileOutputStream(new File(getDir()+"\\Book2.xlsx"));
            FileInputStream in = new FileInputStream(new File(getDir()+"\\Book2.xlsx"));

           org.apache.poi.ss.usermodel.Workbook workbook = new XSSFWorkbook(in);
            org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(0);

           sheet.createRow(0).createCell(0).setCellValue("hello");

            workbook.write(out);
            workbook.close();


        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            Logger.getLogger(JavaApplication4.class.getName()).log(Level.SEVERE, null, ex);
        }


    }

    /**
     * @return the dir
     */
    public static String getDir() {
        return dir;
    }

    /**
     * @param dir the dir to set
     */
    public static void setDir(String directory) {
        dir = directory;
    }

}

..当我运行它时，出现以下错误:

..And when I run it I get the following error:

Exception in thread "main" org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file
    at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:286)
    at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:758)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:327)
    at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:291)
    at javaapplication4.JavaApplication4.main(JavaApplication4.java:46)
C:\Users\kamal\AppData\Local\NetBeans\Cache\8.2\executor-snippets\run.xml:53: Java returned: 1
BUILD FAILED (total time: 7 seconds)

我在youtube中查找了此代码，并且相同，但是我不确定为什么会收到错误消息?你能帮我吗?

I looked up this code in youtube and it's same but i'm not sure why am i getting the error? Can you help me with this?

推荐答案

好的.今天我遇到了同样的问题.服务器是linux，excel文件通过winscp从Windows复制到linux.Winscp具有诸如以 binary模式，文本模式等传输文件的选项.当我们通过文本模式复制excel文件时，遇到了与您提到的相同的错误.使用二进制模式复制excel文件时，错误得到解决.总而言之，出现此问题是因为我们将Excel文件从Windows复制到了Linux.如果使用winscp，只需确保以二进制模式复制即可.确保正确复制文件.

Okay. Today I encountered the same problem . The server was linux and the excel file is copied from windows to linux through winscp. Winscp has options like transferring the file in binary mode , text mode etc. When we copy the excel file through text mode , I got the same error you mentioned. The error got resolved when I copy the excel file using binary mode. To summarize , this issue came because we copied excel file from windows to linux. Just make sure you are copying in binary mode if using winscp. Make sure the file is copied correctly.

这篇关于如何在Java Apache POI中修复NotOfficeXmlFileException?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！