CODEWITHSUNDEEP
javaexcelapache-poi
wacik93
wacik93

Reputation: 293

Multiple hyperlinks in one cell

I have got a problem connected with hyperlinks in Excel. I would like to have few hyperlinks in one cell. Is it possible? I read something about rectangles in which I should put each link, but I have no clue how to do this.

Upvotes: 1

Views: 5165

Answers (1)

Andy Turner
Andy Turner

Reputation: 140319

Putting aside POI, I looked to see if it is actually possible to have multiple hyperlinks in a cell in Excel itself:

http://excel.tips.net/T002805_Putting_More_than_One_Hyperlink_in_a_Cell.html

The short answer is that this cannot be done. Excel only allows you to enter hyperlinks on a cell-by-cell basis. Even if you add the hyperlinks to adjacent cells, and then merge the cells into one, only the first hyperlink is maintained by Excel.

As such, POI can't do this either.

Upvotes: 4

Related Questions