Search in sources :

Example 1 with XLSX2CSV

use of com.jeesuite.common2.excel.convert.XLSX2CSV in project jeesuite-libs by vakinge.

the class ExcelPerfModeReader method readAsXLSX.

private List<String> readAsXLSX(String path) {
    OPCPackage opcPackage = null;
    try {
        opcPackage = OPCPackage.open(path, PackageAccess.READ);
        XLSX2CSV xlsx2csv = new XLSX2CSV(opcPackage, System.out, -1);
        return xlsx2csv.process();
    } catch (Exception e) {
        if (e instanceof OLE2NotOfficeXmlFileException || e instanceof NotOLE2FileException || e instanceof NotOfficeXmlFileException || e instanceof OfficeXmlFileException) {
            throw new ExcelOperBaseException("请选择正确格式excel文件");
        }
        if (e instanceof IOException) {
            throw new ExcelOperBaseException("文件读取失败");
        }
        if (e instanceof InvalidOperationException) {
            throw new ExcelOperBaseException(e);
        }
        throw new RuntimeException(e);
    } finally {
        try {
            opcPackage.close();
        } catch (Exception e) {
        }
    }
}
Also used : NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException) OLE2NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException) OfficeXmlFileException(org.apache.poi.poifs.filesystem.OfficeXmlFileException) NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException) OLE2NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException) NotOLE2FileException(org.apache.poi.poifs.filesystem.NotOLE2FileException) InvalidOperationException(org.apache.poi.openxml4j.exceptions.InvalidOperationException) OLE2NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException) IOException(java.io.IOException) OPCPackage(org.apache.poi.openxml4j.opc.OPCPackage) XLSX2CSV(com.jeesuite.common2.excel.convert.XLSX2CSV) OfficeXmlFileException(org.apache.poi.poifs.filesystem.OfficeXmlFileException) NotOLE2FileException(org.apache.poi.poifs.filesystem.NotOLE2FileException) IOException(java.io.IOException) InvalidOperationException(org.apache.poi.openxml4j.exceptions.InvalidOperationException) NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException) OLE2NotOfficeXmlFileException(org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException)

Aggregations

XLSX2CSV (com.jeesuite.common2.excel.convert.XLSX2CSV)1 IOException (java.io.IOException)1 InvalidOperationException (org.apache.poi.openxml4j.exceptions.InvalidOperationException)1 NotOfficeXmlFileException (org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException)1 OLE2NotOfficeXmlFileException (org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException)1 OPCPackage (org.apache.poi.openxml4j.opc.OPCPackage)1 NotOLE2FileException (org.apache.poi.poifs.filesystem.NotOLE2FileException)1 OfficeXmlFileException (org.apache.poi.poifs.filesystem.OfficeXmlFileException)1