aspose 转pdf表格大小乱了_java下用aspose.cell基于Excel模板导出PDF文件异常

我用Spire.XLS for Java类库来进行Excel转PDF没出现这个问题呢,Excel表格过宽的话,导出来的PDF宽度也会相应变宽,同时还可进行页面大小设置。你可下载免费版试试。https://www.e-iceblue.cn/Downloads/Free-Spire-XLS-JAVA.html 以下代码可供参考:

import com.spire.xls.*;

public class toPdfWithChangePageSize {

public static void main(String[] args) {

//Create a workbook

Workbook workbook = new Workbook();

workbook.loadFromFile("C:\Users\Test1\Desktop\Sample.xlsx");

for(int i = 0; i < workbook.getWorksheets().getCount(); i ++)

{

Worksheet worksheet = workbook.getWorksheets().get(i);

//Change the page size

worksheet.getPageSetup().setPaperSize(PaperSizeType.PaperA3);

}

//Save to PDF file

workbook.saveToFile("output/toPdfWithChangePageSize.pdf", FileFormat.PDF);

}

}