注:机器或服务器上装有excel
首先需要有jacob.dll和jacob.jar
将jacob.dll放在system32和myeclipse的bin目录下
将jacob.jar放在工程的lib目录下
首先需要有jacob.dll和jacob.jar
将jacob.dll放在system32和myeclipse的bin目录下
将jacob.jar放在工程的lib目录下
然后进行编码操作
public static void excelToHtml(String docfile, String htmlfile)
{
ActiveXComponent app = new ActiveXComponent("Excel.Application"); // 启动word
try
{
app.setProperty("Visible", new Variant(false));
Dispatch docs = app.getProperty("Workbooks").toDispatch();
Dispatch doc = Dispatch.invoke(
docs,
"Open",
ispatch.Method,
new Object[] { docfile, new Variant(false),
new Variant(true) }, new int[1]).toDispatch();
Dispatch.invoke(doc, "SaveAs", Dispatch.Method, new Object[] {
htmlfile, new Variant(44}, new int[1]);
Variant f = new Variant(false);
Dispatch.call(doc, "Close", f);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
app.invoke("Quit", new Variant[] {});
}
}
ActiveXComponent app = new ActiveXComponent("Excel.Application"); // 启动word
try
{
app.setProperty("Visible", new Variant(false));
Dispatch docs = app.getProperty("Workbooks").toDispatch();
Dispatch doc = Dispatch.invoke(
docs,
"Open",
ispatch.Method,
new Object[] { docfile, new Variant(false),
new Variant(true) }, new int[1]).toDispatch();
Dispatch.invoke(doc, "SaveAs", Dispatch.Method, new Object[] {
htmlfile, new Variant(44}, new int[1]);
Variant f = new Variant(false);
Dispatch.call(doc, "Close", f);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
app.invoke("Quit", new Variant[] {});
}
}
public static void main(String[] strs)
{
WordToHtml.change("夏新test.xlsx"夏新test.html");
}
WordToHtml.change("夏新test.xlsx"夏新test.html");
}
转载于:https://blog.51cto.com/xiasxjy/130598