Illegal Access Error when instantiating Workbook

[yangiiyu]

I want to convert an excel file to a PDF but I get an error when I instantiate the Workbook class.

Code: Select all

import java.io.IOException;

import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;

public class ExcelConversion {

   public void convert() throws IOException {
      
      Workbook workbook = new Workbook();
        workbook.loadFromFile("yes.xlsx");

        //Save as PDF document
        workbook.saveToFile("ExcelToPDF.pdf",FileFormat.PDF);
      
   }
}


java.lang.IllegalAccessError: class com.spire.xls.packages.sprRFA (in unnamed module @0xfe48b45) cannot access class sun.security.action.GetPropertyAction (in module java.base) because module java.base does not export sun.security.action to unnamed module

I'm using spire.xls.free version 5.1.0 with the intention of purchasing the product if it works.

[Marcia.Zhou]

Hello,

Thanks for your inquiry!

To help us better investigate in your issue, please provide us with the following information. Thanks in advance!

1. Your JDK version (E.g. oracle JDK 1.8.0_271).
2. Your system information (E.g. Win7, 64 bit) and region setting (E.g. China, Chinese).
3. The file you were using (yes.xlsx).
4. Your project type (E.g. spring boot project).

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, my JDK version is Java 11, I'm using an M1 Mac running on OS Monterey, and the project is springboot. The error occurs during the Workbook instantiation, before Workbook#loadFromFile is called so I don't think it's an issue with the excel file I am trying to load.

these are my dependencies and repositories:

Code: Select all

<dependencies>
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-web</artifactId>
      </dependency>
      <dependency>
         <groupId>com.hynnet</groupId>
         <artifactId>pdfjet</artifactId>
         <version>5.75</version>
      </dependency>
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-test</artifactId>
         <scope>test</scope>
      </dependency>
      <dependency>
         <groupId>org.apache.poi</groupId>
         <artifactId>poi</artifactId>
         <version>5.1.0</version>
      </dependency>
      <dependency>
         <groupId>org.apache.poi</groupId>
         <artifactId>poi-ooxml</artifactId>
         <version>5.1.0</version>
      </dependency>
      <dependency>
         <groupId>org.apache.pdfbox</groupId>
         <artifactId>pdfbox</artifactId>
         <version>2.0.25</version>
      </dependency>
      <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-databind</artifactId>
       </dependency>
       <dependency> 
          <groupId>org.json</groupId> 
          <artifactId>json</artifactId> 
          <version>20180130</version> 
      </dependency>
      <dependency>
          <groupId>com.github.javadev</groupId>
          <artifactId>underscore</artifactId>
          <version>1.73</version>
      </dependency>
      <dependency>
         <groupId>net.sf.jasperreports</groupId>
         <artifactId>jasperreports</artifactId>
         <version>6.18.1</version>
      </dependency>
      <dependency>
          <groupId>e-iceblue</groupId>
          <artifactId>spire.xls.free</artifactId>
          <version>5.1.0</version>
      </dependency>
   </dependencies>
   <repositories>
        <repository>
            <id>com.e-iceblue</id>
            <name>e-iceblue</name>
            <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
        </repository>
   </repositories>

[Marcia.Zhou]

Hello,

Thanks for sharing more information!

I simulated a simple project and run it on Mac Monterey with JDK 11.0.2, but did not reproduce your issue. Here I also attached the jar file I tested with.

system.png (66.65 KiB) Viewed 6089 times

Could you please provide us with the project or jar file you were testing for further investigate? Thanks in advance.

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, I wasn't able to look inside the jar file you provided, but here is the class that I was using for testing. It's a Springboot RestController so it doesn't interact with any other classes in the project.

[Marcia.Zhou]

Hello,

Thanks for sharing more information!

I simulated a Spring Boot project according to your maven information. But this project still can run successfully in MAC. Here I attached my whole project.

You can also try our latest Spire.Xls for java 5.1.5 to see if the issue still exists. Or please provide us with a simple project ti reproduce your issue. Thanks in advance.

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, I'm still unable to get my project to work, so I created a simple example of what I'm currently doing and attached it here.

[Marcia.Zhou]

Hello,

Thanks for sharing your project.

Sorry that I still cannot reproduce the Illegal issue you mentioned by the project you provided. Did you try the project I attached in the last post?

Besides, could you please provide us with the detail step that you tested with? Here I also attached my steps. You can also send us a video via email(support@e-iceblue.com). Thanks in advance.

step.png (88.2 KiB) Viewed 6076 times

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, I downloaded the jar file that you sent me but I'm not able to view freeDoc.class or any of the jar files inside. How I'm currently running my spring project is directly calling

./mvnw spring-boot:run

from the command line (I'm not compiling it to an artifact). I then use

curl localhost:8080/excel-pdf

whereby I run into the IllegalAccessError:

Code: Select all

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.IllegalAccessError: class com.spire.xls.packages.sprRFA (in unnamed module @0xfe48b45) cannot access class sun.security.action.GetPropertyAction (in module java.base) because module java.base does not export sun.security.action to unnamed module @0xfe48b45] with root cause

java.lang.IllegalAccessError: class com.spire.xls.packages.sprRFA (in unnamed module @0xfe48b45) cannot access class sun.security.action.GetPropertyAction (in module java.base) because module java.base does not export sun.security.action to unnamed module @0xfe48b45
   at com.spire.xls.packages.sprRFA.spr  (Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.packages.sprRFA.spr  (Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.packages.sprRFA.<init>(Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.packages.sprksa.<init>(Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.packages.sprHTa.<init>(Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.core.spreadsheet.XlsWorkbook.<init>(Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.spire.xls.Workbook.<init>(Unknown Source) ~[spire.xls.free-5.1.0.jar:5.1.0]
   at com.example.demo.DemoApplication.getPdf(DemoApplication.java:23) ~[classes/:na]

[Marcia.Zhou]

Hello,

I tested your project with "./mvnw" method, but still cannot reproduce the issue, the project can run normally and generate the PDF file. So I do more search about the issue "module java.base does not export sun.security.action to unnamed module" you mentioned and found that this issue may be related to the JDK version.(According to this:https://stackoverflow.com/questions/66690687/im-starting-to-learn-spring-boot-and-i-run-into-this-error)

result.png (86.78 KiB) Viewed 6055 times

Could you please provide us with the JDK version of your Mac to help us reproduce your environment? Thanks in advance.

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, thanks for your response, this is what I get when I run java-version:

java version "17.0.1" 2021-10-19 LTS
Java(TM) SE Runtime Environment (build 17.0.1+12-LTS-39)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.1+12-LTS-39, mixed mode, sharing)

[Marcia.Zhou]

Hello,

Thanks for your feedback!

Kindly note that in your project, you have set the target running JDK version to JavaSE-11. But since the JDK version of your Mac is JavaSE-17, the difference between these two cause the Illegal issue you meet. Please remove the JavaSE-17, and then download and set the JavaSE-11 to your Mac, and then the issue will not exist anymore.

YourProjectSetting.png (17.73 KiB) Viewed 6050 times

Sincerely,
Marcia
E-iceblue support team

[yangiiyu]

Hi, thank you so much for your help! I had some issues installing Java 11 due to ARM architecture, but I managed to fix them and get the library to work Now i just need to figure out how to convert pdf back to excel... if all goes well, my company will be purchasing the full version of this software.

[Marcia.Zhou]

Hello,

You are welcome!

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team