开发者

How to write two hyperlink in Excel cell using java

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜