Hi:

I can use such code to create a hyper link with poi to link to some outer file.
CreationHelper createHelper = wb.getCreationHelper();
Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_FILE);
link.setAddress("E:/Test.xlsx");

But I failed to link to the cell use below code:
link.setAddress("E:/Test.xlsx#Sheet!A10");

I know I can use such code to do it :
cell.setCellFormula("HYPERLINK(\"E:/Test.xlsx#Sheet!A10\",\"Link\")");

But my question is if there is any other way to solve this issue ?
Just Like :
link.setAddress("E:/Test.xlsx#Sheet!A10");

Regards
Yin

Reply via email to