Hi !
I'm using the code below :
public void writeInCell(String type, String value, String adress, String
sheetName){
Row rowLink = null;
Cell cellLink = null;
int idLine = 0;
int idColonne = 0;
if(type.equals("PPR")){
idLine = mapLine.get("PPR");
idColonne = mapColumn.get("PPR");
rowLink =
sheetLink.createRow(idLine);
cellLink = rowLink.createCell(idColonne);
cellLink.setCellValue(value);
HSSFHyperlink theLink = (HSSFHyperlink)createHelper.
createHyperlink(Hyperlink.LINK_URL);
theLink.setAddress("350_Commercial.xls'#'PCM_350!A1");
cellLink.setHyperlink(theLink);
cellLink.setCellStyle(linkStyle);
idLine++;
mapLine.put("PPR", idLine);
}
}
I need to build a link to another workbook but also to a particular sheet
into this workbook. I have tried to set the address as
"350_Commercial.xls'#'PCM_350!A1" but when I click on the cell the link
does'nt work. After generating the Excel file, I have noticed that the
character # was replaced by %23. How can I change the address to make it
work?
Thanks for your help!
Jiybee
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Trouble-with-HyperLink-to-another-cell-in-another-wokbook-tp5603614p5603614.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]
