-
大小: 0.03M文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2021-02-01
- 語言: Java
- 標簽:
資源簡介
Java 將Excel文件轉(zhuǎn)換為HTML格式(基礎(chǔ)篇-實例484).zip
代碼片段和文件信息
import?com.jacob.activeX.ActiveXComponent;
import?com.jacob.com.Dispatch;
import?com.jacob.com.Variant;
public?class?ExcelToHtml?{
????
????/**
?????*?EXCEL轉(zhuǎn)HTML
?????*?
?????*?@param?xlsfilePath
?????*????????????EXCEL文件全路徑
?????*?@param?htmlfilePath
?????*????????????轉(zhuǎn)換后HTML存放路徑
?????*/
????
public?void?excelToHtml(String?xlsfilePath?String?htmlfilePath)?{
????ActiveXComponent?app?=?new?ActiveXComponent(“Excel.Application“);?//?啟動excel
try?{
????app.setProperty(“Visible“?new?Variant(false));????????????????//設(shè)置Excel對象為不可見
????Dispatch?excels?=?app.getProperty(“Workbooks“).toDispatch();
????Dispatch?excel?=?Dispatch.invoke(
????????????excels
????????????“Open“
????????????Dispatch.Method
????????????new?object[]?{?xlsfilePath?new?Variant(false)
??????????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????284??2013-11-18?09:46??.classpath
?????文件?????????379??2010-09-10?15:22??.project
?????文件?????????629??2010-09-10?15:22??.settings\org.eclipse.jdt.core.prefs
?????文件????????1913??2013-11-21?08:42??bin\ExcelToHtml.class
?????文件???????34468??2013-11-18?09:24??lib\jacob.jar
?????文件????????1457??2010-09-10?15:22??src\ExcelToHtml.java
評論
共有 條評論