/**
* 将指定路径的Excel文件生成Html文件
*
* @param excelFilename
* Excel文件存放路径及文件名,可以是网络地址
* @param htmlFilename
* 生成后的html存放路径及文件名
*/
public static void ExcelToHtml(String excelFilename, String htmlFilename)
{
ActiveXComponent xl = new ActiveXComponent("Excel.Application");
try
{
Dispatch.put(xl, "Visible", new Variant(false));
Object workbooks = xl.getProperty("Workbooks").toDispatch();
Object workbook = Dispatch.call(workbooks, "Open", excelFilename).toDispatch();
Dispatch.invoke(workbook, "SaveAs", Dispatch.Method, new Object[] ...{ htmlFilename, new Variant(44) }, new int[1]);
Dispatch.call(workbooks, "Close", new Variant(false));
}
catch (Exception e)
{
}
finally
{
xl.invoke("Quit", new Variant[] ...{});
xl = null;
}
}