嗨,Iam试图将xlsx转换为pdf使用apache.poi,这是完美的工作,直到我添加一些代码(转换为pdf),需要使用3.17版本。之后,当我试图转换xlsx时,我得到了这个错误。
org.apache.poi.util.POILogger.log(ILjava/lang/Object;Ljava/lang/Throwable;)V:
java.lang.NoSuchMethodError
我不知道会发生什么。不管怎么说,这是我的一些代码来获取文件
ByteArrayOutputStream baos = new ByteArrayOutputStream();
OPCPackage pkg = OPCPackage.open(file);
XSSFWorkbook xls = new XSSFWorkbook(pkg);
XSSFSheet worksheet = xls.getSheetAt(0);OPCPackage打开文件(InputStream)时出错。有人能帮我吗?
Lib : poi 3.17和所有依赖项,itextpdf 5.5.13
发布于 2020-01-24 09:39:03
请检查您的依赖项的实际版本(例如,使用mvn dependency:tree)。
我认为poi 3.17和itextpdf 5.5.13没有什么问题。下面是pom的单元测试通过了。
package stackoverflow.q59892610;
import org.junit.Rule;
import org.junit.Test;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.rules.TemporaryFolder;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.UUID;
import static org.apache.poi.xssf.usermodel.XSSFWorkbookType.XLSX;
import static org.junit.Assert.*;
public class PoiTest
{
@Rule
public TemporaryFolder folder= new TemporaryFolder(new File("target"));
@Test
public void xlsTest() throws Exception
{
File file = new File(folder.getRoot(), UUID.randomUUID() + ".xlxs");
String cellValue = UUID.randomUUID().toString();
try (XSSFWorkbook xls = new XSSFWorkbook(XLSX)) {
xls.createSheet("new sheet").createRow(0).createCell(0).setCellValue(cellValue);
try(OutputStream out = new FileOutputStream(file)) {xls.write(out);}
}
ByteArrayOutputStream baos = new ByteArrayOutputStream();
XSSFWorkbook xls = new XSSFWorkbook(file);
XSSFSheet worksheet = xls.getSheetAt(0);
assertEquals("cell value mismatch", cellValue, worksheet.getRow(0).getCell(0).getStringCellValue());
}
}<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>stackoverflow</groupId>
<artifactId>poi-logger</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>poi-logger</name>
<url>http://maven.apache.org</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<poi-version>3.17</poi-version>
<itextpdf-version>5.5.13</itextpdf-version>
<junit-version>4.13</junit-version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${junit-version}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>${poi-version}</version>
</dependency>
<dependency>
<groupId>com.itextpdf</groupId>
<artifactId>itextpdf</artifactId>
<version>${itextpdf-version}</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>${poi-version}</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>https://stackoverflow.com/questions/59892610
复制相似问题