Hi to all,
I need to write a xls file in which a cell has formula type. this formula
has to contain a link to external xls file.
This is code:
String formula =
"LOOKUP([test.xls]master!$G$7,[test.xls]master!$G$5:$G$26,[test.xls]master!$G$5:$G$26)";
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
HSSFRow row = sheet.createRow(1);
HSSFCell cell = row.createCell(0, HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(formula);
This is the exception:
java.lang.RuntimeException: No external workbook with name test.xls'
I have the same exception if complete path of file is specified.
Please help me
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/set-cell-formula-whit-a-link-tp4513502p4513502.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
