I have updated my ExcelImporter from 8 something to 9.2.3 and I have a modified java code and i’m importing a library using this ‘import org.apache.poi.xssf.usermodel.XSSFColor;’. However, when I deleted the old library and keep the new library. I’m getting an error once I run the app. it’s getting compilation errors due to Java Functions. The screenshot below shows the new library that I kept and I deleted the old version 4.1.1. For additional error info, I also had the set of errorlist below the screenshot. Buildfile: D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\deployment\build_core.xml compile: [javac] Compiling 620 source files to D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\deployment\run\bin [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\audittrail\log\diff_match_patch.java:1806: warning: [dep-ann] deprecated item is not annotated with @Deprecated [javac] public LinkedList<Patch> patch_make(String text1, String text2, [javac] ^ [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\communitycommons\Misc.java:590: warning: [dep-ann] deprecated item is not annotated with @Deprecated [javac] public static boolean objectsAreEqual(Object left, Object right) { [javac] ^ [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:169: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor blueindex = new XSSFColor(new java.awt.Color(153,153,255)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:171: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor redindex = new XSSFColor(new java.awt.Color(255,128,128)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:176: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor firstcolindex = new XSSFColor(new java.awt.Color(255,192,0)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:178: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor secondcolindex = new XSSFColor(new java.awt.Color(220,230,241)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:180: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor thirdcolindex = new XSSFColor(new java.awt.Color(255,255,153)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:182: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor fourthcolindex = new XSSFColor(new java.awt.Color(253,233,217)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:184: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor fifthcolindex = new XSSFColor(new java.awt.Color(238,236,225)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:186: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor sixthcolindex = new XSSFColor(new java.awt.Color(197,190,151)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:187: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor seventhcolindex = new XSSFColor(new java.awt.Color(191,191,191)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcel.java:321: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor brownindex = new XSSFColor(new java.awt.Color(197, 191, 151)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:163: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor blueindex = new XSSFColor(new java.awt.Color(153,153,255)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:165: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor redindex = new XSSFColor(new java.awt.Color(255,128,128)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:170: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor firstcolindex = new XSSFColor(new java.awt.Color(255,192,0)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:172: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor secondcolindex = new XSSFColor(new java.awt.Color(220,230,241)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:174: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor thirdcolindex = new XSSFColor(new java.awt.Color(255,255,153)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:176: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor fourthcolindex = new XSSFColor(new java.awt.Color(253,233,217)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:178: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor fifthcolindex = new XSSFColor(new java.awt.Color(238,236,225)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:180: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor sixthcolindex = new XSSFColor(new java.awt.Color(197,190,151)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:182: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor seventhcolindex = new XSSFColor(new java.awt.Color(191,191,191)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\javasource\xlsreport\report\export\ExportExcelMI.java:315: error: no suitable constructor found for XSSFColor(Color) [javac] XSSFColor brownindex = new XSSFColor(new java.awt.Color(197, 191, 151)); [javac] ^ [javac] constructor XSSFColor.XSSFColor(IndexedColorMap) is not applicable [javac] (argument mismatch; Color cannot be converted to IndexedColorMap) [javac] constructor XSSFColor.XSSFColor(byte[]) is not applicable [javac] (argument mismatch; Color cannot be converted to byte[]) [javac] Note: Some input files use or override a deprecated API. [javac] Note: Recompile with -Xlint:deprecation for details. [javac] Note: Some messages have been simplified; recompile with -Xdiags:verbose to get full output [javac] 20 errors [javac] 2 warnings BUILD FAILED D:\Continenal Projects\LVPF Forecasting Tool-MaintenanceBranch_9.2.3\deployment\build_core.xml:29: Compile failed; see the compiler error output for details. Total time: 2 minutes 11 seconds
asked
John Laurence Gamas
2 answers
0
I don’t think that library is the problem. The newest Excel Importer and Exporter modules are using the 5.2.2 version of Apache POI. The issue is I think in the ooxml-schemas library. That is used by older Apache POI libraries but not by 5.2.2. Try to delete that one and see if you still see this issue.
EDIT:
These are the libraries needed for Apache POI v5.2.2. As mentioned, be sure to delete the ooxml-schemas jar which came with older Excel Import/Exporter versions coming with older Apache POI versions
answered
Ivo Sturm
0
Hi Ivo,
These are the screenshots I mentioned.
1st – The appearance of my userlib/ files
2nd screenshot: The java compile errors I get on my project