package com.qlzx.utils;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import com.aspose.cells.License;
import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
import org.aspectj.weaver.ast.Test;
/**利用aspose
- excel 转PDF 可以用
- @author Liang Qizhao
*/
public class ExcelToPdf {
/**
* 获取license
*
* @return
*/
public static boolean getLicense() {
boolean result = false;
try {
InputStream is = Test.class.getClassLoader().getResourceAsStream("\\license.xml");
License aposeLic = new License();
aposeLic.setLicense(is);
result = true;
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
* @param args
*/
public static void excel2pdf(String inPath, String outPath) {
// 验证License
if (!getLicense()) {
return;
}
try {
long old = System.currentTimeMillis();
Workbook wb = new Workbook(inPath);// 原始excel路径
File pdfFile = new File(outPath);// 输出路径
FileOutputStream fileOS = new FileOutputStream(pdfFile);
wb.save(fileOS, SaveFormat.PDF);
long now = System.currentTimeMillis();
System.out.println("共耗时:" + ((now - old)) + "秒");
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
excel2pdf("C:\\Users\\Liang Qizhao\\Desktop\\测试数据\\3-4季度形象进度表1.xlsx", "C:\\Users\\Liang Qizhao\\Desktop\\11.pdf");
}
}
license.xml 放在resources下,可以去除水印,不然转成的PDF会有水印
Aspose.Total for Java
Aspose.Words for Java
Enterprise
20991231
20991231
8bfe198c-7f0c-4ef8-8ff0-acc3237bf0d7
sNLLKGMUdF0r8O1kKilWAGdgfs2BvJb/2Xp8p5iuDVfZXmhppo+d0Ran1P9TKdjV4ABwAgKXxJ3jcQTqE/2IRfqwnPf8itN8aFZlV3TJPYeD3yWE7IT55Gz6EijUpC7aKeoohTb4w2fpox58wWoF3SNp6sK6jDfiAUGEHYJ9pjU=