我正在尝试在Java中使用jxl将HYPERLINK写入excel，但是写入失败，如下所示。请提出可以做什么
String scn = "=HYPERLINK(\"D:\\snaps\\"+step_num+".jpg\",\"Click\")";
Formula link = new Formula(3,0,scn);
wws.addCell(link);
java.util.EmptyStackException
at java.util.Stack.peek(Unknown Source)
at java.util.Stack.pop(Unknown Source)
at jxl.biff.formula.BinaryOperator.getOperands(BinaryOperator.java:61)
at jxl.biff.formula.StringFormulaParser.parseCurrent(StringFormulaParser.java:240)
at jxl.biff.formula.StringFormulaParser.parse(StringFormulaParser.java:113)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:129)
at jxl.write.biff.FormulaRecord.initialize(FormulaRecord.java:160)
at jxl.write.biff.FormulaRecord.setCellDetails(FormulaRecord.java:243)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1155)
at framework.WrapperMethods.writeExcel(WrapperMethods.java:174)
at framework.WrapperMethods.setValueById(WrapperMethods.java:80)
at sample.T24Login.main(T24Login.java:55)
通过删除更改 =
从
String scn = "=HYPERLINK(\"D:\\snaps\\"+step_num+".jpg\",\"Click\")";
至
String scn = "HYPERLINK(\"D:\\snaps\\"+step_num+".jpg\",\"Click\")";
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句