html csv 转excel,Java - Excel 转HTML、PDF、CSV

最下边 gitee / github demo源码

最近做一个Excel转 html的需求，于是。 。。

用到了aspose-cells 包 ，可以选择官网下载，也可以gitte或github！！

文件目录

解决方法

分别是一个获取License， 2个转换类，一个转换的方法！

最主要的代码，需要改动的！！！(32-48行)自己的文件路径

class AsposeDemoApplicationTests {

/**

* 获取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;

}

/**

* 支持DOC, DOCX, OOXML, RTF, HTML, OpenDocument, PDF, EPUB, XPS, SWF等相互转换

*

* @param args

*/

public static void main(String[] args) {

// 验证License

if (!getLicense()) {

return;

}

try {

long old = System.currentTimeMillis();

// 转换html

ExcelConvertToHtml("D:\\\\BaiduNetdiskDownload\\\\aspose-demo\\\\src\\\\main\\\\resources\\\\static\\\\aaa.xlsx",

"D:\\\\BaiduNetdiskDownload\\\\aspose-demo\\\\src\\\\main\\\\resources\\\\static\\\\aaa.html");

// 转换csv

ExcelConvertToCSV("D:\\\\BaiduNetdiskDownload\\\\aspose-demo\\\\src\\\\main\\\\resources\\\\static\\\\aaa.xlsx",

"D:\\\\BaiduNetdiskDownload\\\\aspose-demo\\\\src\\\\main\\\\resources\\\\static\\\\aaa.csv");

// 转换pdf

Workbook wb = new Workbook("D:\\BaiduNetdiskDownload\\aspose-demo\\src\\main\\resources\\static\\aaa.xlsx");// 原始excel路径

File pdfFile = new File("D:\\BaiduNetdiskDownload\\aspose-demo\\src\\main\\resources\\static\\aaa.pdf");// 输出路径

FileOutputStream fileOS = new FileOutputStream(pdfFile);

wb.save(fileOS, SaveFormat.PDF);

long now = System.currentTimeMillis();

System.out.println("共耗时：" + ((now - old) / 1000.0) + "秒");

} catch (Exception e) {

e.printStackTrace();

}

}

/**

* Excel 2 csv转换类

* @param sourceFilePath 传入路径

* @param csvFilePath 输出路径

* @throws Exception 异常

*/

public static void ExcelConvertToCSV(String sourceFilePath, String csvFilePath)

throws Exception {

com.aspose.cells.Workbook excel = null;

excel = new com.aspose.cells.Workbook(sourceFilePath);

excel.save(csvFilePath, com.aspose.cells.SaveFormat.CSV);

}

/**

* Excel 2 HTML转换类

* @param sourceFilePath 传入路径

* @param htmlFilePath 输出路径

* @throws Exception 异常

*/

public static void ExcelConvertToHtml(String sourceFilePath, String htmlFilePath)

throws Exception {

com.aspose.cells.LoadOptions loadOption = null;

com.aspose.cells.Workbook excel = null;

if (sourceFilePath != null

&& !sourceFilePath.isEmpty()

&& sourceFilePath

.substring(sourceFilePath.lastIndexOf("."))

.toLowerCase() == ".csv") {

loadOption = new com.aspose.cells.TxtLoadOptions(

com.aspose.cells.LoadFormat.AUTO);

}

if (loadOption != null) {

excel = new com.aspose.cells.Workbook(sourceFilePath, loadOption);

} else {

excel = new com.aspose.cells.Workbook(sourceFilePath);

}

excel.save(htmlFilePath, com.aspose.cells.SaveFormat.HTML);

}

}

license.xml

Aspose.Total for Java

Aspose.Words for Java

Enterprise

20991231

20991231

8bfe198c-7f0c-4ef8-8ff0-acc3237bf0d7

sNLLKGMUdF0r8O1kKilWAGdgfs2BvJb/2Xp8p5iuDVfZXmhppo+d0Ran1P9TKdjV4ABwAgKXxJ3jcQTqE/2IRfqwnPf8itN8aFZlV3TJPYeD3yWE7IT55Gz6EijUpC7aKeoohTb4w2fpox58wWoF3SNp6sK6jDfiAUGEHYJ9pjU=

示例图片

运行

结果：

带有多sheet页

pdf:

github地址：https://github.com/Beful/aspose-demo

gitee地址：https://gitee.com/zhangx00098/aspose-demo