OpenOffice转excel为pdf时出现折行 设置打印页面缩放和页面尺寸
参考此大佬链接:
fs = new POIFSFileSystem(new FileInputStream("D:/test.xls");
wb = new HSSFWorkbook(fs);
for (int i = 0; i < wb.getNumberOfSheets(); i++) {
Sheet sheet = wb.getSheetAt(i);
sheet.getPrintSetup().setScale((short) 80); // 设置打印页面缩放
sheet.getPrintSetup().setPaperSize(PrintSetup.LEDGER_PAPERSIZE);// 设置打印尺寸
sheet.setHorizontallyCenter(true);//设置打印页面为水平居中
wb.write(new File("D:/testnew.xls"));
}
<dependency>
<groupId>org.jodconverter</groupId>
<artifactId>jodconverter-core</artifactId>
<version>4.3.0</version>
</dependency>
<dependency>
<groupId>org.jodconverter</groupId>
<artifactId>jodconverter-local</artifactId>
<version>4.3.0</version>
</dependency>
<dependency>
<groupId>org.jodconverter</groupId>
<artifactId>jodconverter-spring-boot-starter</artifactId>
<version>4.3.0</version>
</dependency>
<!-- poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>