Ability to read hyperlinks from .xlsx and .xls files in Ruby

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.

Taidot: Ruby

Näytä lisää: ruby spreadsheet, how to read data from excel file in ruby, rubyxl, roo gem tutorial, ole::storage::formaterror: ole2 signature is invalid, ruby excel spreadsheet xlsx, ruby roo gem, ruby axlsx, bel india com read more at https www sarkariexaam com jobs details 2015 12 16 bharat electronics limited contract engineer 14293, combine several xls files, uploading xls files ruby, read xls files ruby rails, read plist files ruby, make indesign read xls files, php read text pdf ppt xls files, perl script process xls files, yellow pages xls files, upload xls files using php, read skype history dbb files, reading xls files perl

Tietoa työnantajasta:
( 5 arvostelua ) Otley, United States

Projektin tunnus: #15804488

Myönnetty käyttäjälle:


Hello, I have gone through your proposal, i can do this job. Relevant Skills and Experience Openfire, JavaScript, AngularJS, JQuery, HTML5/CSS3, Bootstrap(responsive), PostgreSQ Proposed Milestones $111 USD - 1

$100 USD 2 päivässä
(7 Arvostelua)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hey ! I'm SAYAN PROGRAMMER I've reviewed your complete job description. I have more than 15 years of experience in this field. if you will respond me then I will be able to explain my skills. Relevant Skills and Ex Lisää

$50 USD 3 päivässä
(0 arvostelua)