开发者

How to write two hyperlink in Excel cell using java

开发者 https://www.devze.com 2022-12-22 04:52 出处:网络
Is there is any way to write hyperlink in Excel cell using java. e.g. I want to write two hyperlink in one cell.

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

精彩评论

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