java.lang.ClassNotFoundException: org.apache.xml.serializer.OutputPropertiesFactory is thrown after upgrading xalan to 2.7.3

huangapple
go评论109阅读模式
英文:

java.lang.ClassNotFoundException: org.apache.xml.serializer.OutputPropertiesFactory is thrown after upgrading xalan to 2.7.3

问题

I have java code that exports some data into an excel file. ( I only included below what I think are the relevant parts in the code)

Everything worked fine but then I upgraded my xalan from 2.7.2 to 2.7.3 and it stoped working.
the reason - java.lang.ClassNotFoundException: org.apache.xml.serializer.OutputPropertiesFactory

The exception is thrown at the 'wb.write(fileOutputStream);' line under the export() method

  1. import org.apache.logging.log4j.Level;
  2. import org.apache.poi.ss.usermodel.*;
  3. import org.apache.poi.xssf.streaming.SXSSFSheet;
  4. import org.apache.poi.xssf.streaming.SXSSFWorkbook;
  5.      
  6. private Workbook wb;
  8. private void init(String targetPath, String fileName, ExcelExportType exportType) {
  9.     // ...
  10. }
  12. public File export() {
  13.     // ...
  14. }
  16. according to the link, 
  17. [https://xalan.apache.org/xalan-j/][1]
  19. Xalan-Java Version 2.7.3 works with Xerces-Java, and the distribution includes xercesImpl.jar from Xerces-Java 2.12.2.
  21. The Xalan-Java implementation is in xalan.jar and serializer.jar. The SAX, DOM, and JAXP 1.3 interfaces are in xml-apis.jar.
  23. so maybe I need to implement the code in a different way?
  24. any idea how can I solve this?
  26. [1]: https://xalan%202.7.3
英文:

I have java code that exports some data into an excel file. ( I only included below what I think are the relevant parts in the code)

Everything worked fine but then I upgraded my xalan from 2.7.2 to 2.7.3 and it stoped working.
the reason - java.lang.ClassNotFoundException: org.apache.xml.serializer.OutputPropertiesFactory

The exception is thrown at the 'wb.write(fileOutputStream);' line under the export() method

  1. import org.apache.logging.log4j.Level;
  2. import org.apache.poi.ss.usermodel.*;
  3. import org.apache.poi.xssf.streaming.SXSSFSheet;
  4. import org.apache.poi.xssf.streaming.SXSSFWorkbook;
  5.      
  6. private Workbook wb;
  8.             private void init(String targetPath, String fileName, ExcelExportType exportType) {
  9.                 exportedFile = new File(Paths.get(targetPath, fileName  + FILE_EXTENSION).toString());
  10.                 try {
  11.                     fileOutputStream = new FileOutputStream(exportedFile);
  12.                     // if file doesn't exists, then create it
  13.                     if (!exportedFile.exists()) {
  14.                         exportedFile.createNewFile();
  15.                     }
  16.                 } catch (Exception e) {
  17.                     throw new RuntimeException("Init failed. File " + exportedFile.getName() + " cannot be found");
  18.                 }
  19.         
  20.                 switch (exportType) {
  21.                     case MS_EXCEL_2007_AND_UP_STREAMING:
  22.                         wb = new SXSSFWorkbook();
  23.                         break;
  24.                     default:
  25.                         throw new RuntimeException("Unsupported export type");
  26.                 }
  27.         
  28.                 wb.setMissingCellPolicy(Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
  29.                 creationHelper = wb.getCreationHelper();
  30.                 sheet = wb.createSheet(getSheetName());
  31.                 Font font = wb.createFont();
  32.                 font.setFontName(DEFAULT_FONT_NAME);
  33.         
  34.                 if(sheet instanceof SXSSFSheet) {
  35.                     ((SXSSFSheet) sheet).trackAllColumnsForAutoSizing();
  36.                 }
  37.         
  38.                 format = wb.createDataFormat();
  39.         
  40.                 headerFont = wb.createFont();
  41.                 headerFont.setFontName(DEFAULT_FONT_NAME);
  42.                 headerFont.setBold(true);
  43.         
  44.                 cellFont = wb.createFont();
  45.                 cellFont.setFontName(DEFAULT_FONT_NAME);
  46.         
  47.             }
  48.         
  49.         public File export() {
  50.             double factor = 390;
  51.             for (int i = 0; i < numOfColumns; i++) {
  52.                 sheet.autoSizeColumn(i);
  53.                 sheet.setColumnWidth(i, getWidth((int)(maxColumnWidth.get(i) * factor)));
  54.             }
  55.         
  56.             sheet.createFreezePane(0,1);
  57.         
  58.             try {
  59.                 wb.write(fileOutputStream);
  60.                 fileOutputStream.close();
  61.                 wb.close();
  62.             } catch (IOException e) {
  63.                 e.printStackTrace();
  64.             }
  65.         
  66.             return exportedFile;
  67.         }

according to the link,
https://xalan.apache.org/xalan-j/

Xalan-Java Version 2.7.3 works with Xerces-Java, and the distribution includes xercesImpl.jar from Xerces-Java 2.12.2.

The Xalan-Java implementation is in xalan.jar and serializer.jar. The SAX, DOM, and JAXP 1.3 interfaces are in xml-apis.jar.

so maybe I need to implement the code in a different way?
any idea how can I solve this?

答案1

得分: 2

Here is the translation:

通过将这个添加到我的Maven依赖项中进行修复

  1. <dependency>
  2.     <groupId>xalan</groupId>
  3.     <artifactId>serializer</artifactId>
  4.     <version>2.7.3</version>
  5. </dependency>
英文:

fixed by adding this to my maven dependencies

  1.     &lt;dependency&gt;
  2.         &lt;groupId&gt;xalan&lt;/groupId&gt;
  3.         &lt;artifactId&gt;serializer&lt;/artifactId&gt;
  4.         &lt;version&gt;2.7.3&lt;/version&gt;
  5.     &lt;/dependency&gt;

huangapple
  • 本文由 发表于 2023年6月26日 18:20:23
  • 转载请务必保留本文链接：https://go.coder-hub.com/76555759.html
  • excel
  • java
  • xalan
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定