Several existing gems -- roo, simple-spreadsheet, rubyXL -- say they let you read cells that contain hyperlinks. I have tried all of them and have so far failed to be able to read such cells. I just get nil.
I want to be able to determine if a cell contains a hyperlink, and if it does, be able to retrieve both the text (i.e. what's shown to user in spreadsheet), and the link, as I need one or both in various situations.
All of the gems mentioned above provide similar abilities to read and iterate over cells in a spreadsheet, and any of them, or another means of doing the same thing is fine.
I will provide our current Gemfile and Gemfile.lock. Updating or adding gems is fine, except that we can't take the time to upgrade ruby (ruby 2.0.0p648 (2015-12-16 revision 53162) [x86_64-linux]) or rails (3.2.22) right now.