word转换已成功,excel转换出问题了,代码如下
ActiveXComponent xl = new ActiveXComponent("Excel.Application");
try
{
xl.setProperty("Visible", new Variant(false));
boolean readonly = false;
Object workbooks = xl.getProperty("Workbooks").toDispatch();
Object workbook = Dispatch.invoke(workbooks,
"Open",
Dispatch.Method,
new Object[]{paths,
new Variant(false),
new Variant(false)},//是否以只读方式打开
new int[1] ).toDispatch();
Dispatch.invoke(workbook, "SaveAs", Dispatch.Method,
new Object[] { savepaths+filename, new Variant(2) },
new int[1]);
Variant f = new Variant(false);
Dispatch.call(workbook, "Close", f);
} catch (Exception e) {
e.printStackTrace();
} finally {
xl.invoke("Quit", new Variant[] {});
}错误如下:
com.jacob.com.ComFailException: Invoke of: SaveAs
Source: Microsoft Office Excel
Description: at com.jacob.com.Dispatch.invokev(Native Method)
at com.jacob.com.Dispatch.invoke(Dispatch.java)
at eb.hibernate.ToTxt.change(ToTxt.java:129)
at eb.hibernate.ToTxt.main(ToTxt.java:154)
ActiveXComponent xl = new ActiveXComponent("Excel.Application");
try
{
xl.setProperty("Visible", new Variant(false));
boolean readonly = false;
Object workbooks = xl.getProperty("Workbooks").toDispatch();
Object workbook = Dispatch.invoke(workbooks,
"Open",
Dispatch.Method,
new Object[]{paths,
new Variant(false),
new Variant(false)},//是否以只读方式打开
new int[1] ).toDispatch();
Dispatch.invoke(workbook, "SaveAs", Dispatch.Method,
new Object[] { savepaths+filename, new Variant(2) },
new int[1]);
Variant f = new Variant(false);
Dispatch.call(workbook, "Close", f);
} catch (Exception e) {
e.printStackTrace();
} finally {
xl.invoke("Quit", new Variant[] {});
}错误如下:
com.jacob.com.ComFailException: Invoke of: SaveAs
Source: Microsoft Office Excel
Description: at com.jacob.com.Dispatch.invokev(Native Method)
at com.jacob.com.Dispatch.invoke(Dispatch.java)
at eb.hibernate.ToTxt.change(ToTxt.java:129)
at eb.hibernate.ToTxt.main(ToTxt.java:154)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货