Is there is any way to write hyperlink in Excel cell using java.
e.g. I want to write two hyperlink in one cell.
When i click on google.com it shoul开发者_运维百科d open google site and same for yahoo site.
www.google.com | www.yahoo.com
Thanks
It is impossible to have more than one hyperlink per XLS cell. However, that link gives a "cheat" which involves using multiple linked shapes (which I doubt POI supports).
If you are using Apache POI, you can use the setFormula
[1] method of HSSFCell
to write a formula
HYPERLINK("http://example.com")
[1] http://poi.apache.org/spreadsheet/formula.html
精彩评论