1.用JCOB1.9做的
2.源码如下:
public class FileConversion {
private static ActiveXComponent axp;
private static Dispatch dphAll;
private static Dispatch dph;
/**
* 将Excel转化为html
* @param comFile
* @param toFile
*/
public static void excelToHtml(String comFile,String toFile)
{
try {
axp = new ActiveXComponent("Excel.Application");//启动excel
axp.setProperty("Visible", new Variant(false));//设置excel不可见
dphAll= (Dispatch) axp.getProperty("Workbooks").toDispatch(); //
dph= (Dispatch) Dispatch.invoke(dphAll,"Open",
Dispatch.Method,new Object[]{comFile,new Variant(false), new Variant(true)},
new int[1]).toDispatch();//打开临时文件
Dispatch.invoke(dph,"SaveAs", Dispatch.Method, new Object[]{toFile,new Variant(44)},
new int[1]);//以html格式保存
Dispatch.call(dph, "Close", new Variant(false));
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
axp.invoke("Quit", new Variant[] {});
}
}