Paxa / fast_excel

Ultra Fast Excel Writer for Ruby
MIT License
336 stars 59 forks source link

Add a url but setting the anchor's text #69

Open Nerian opened 4 years ago

Nerian commented 4 years ago

Hi,

We can add add urls like this:

worksheet.append_row([
  FastExcel::URL.new("https://github.com/Paxa/fast_excel"),
  FastExcel::URL.new("postgres://localhost")
], url_format)

But how can we add a url to the excel file and set the text that will be the anchor to the url? Essentially I want to show a title, and when the user clicks the title it goes to a url.

Something like this would be useful:

FastExcel::URL.new("Super link", "https://github.com/Paxa/fast_excel"),

How can I do this?

joshuapinter commented 3 months ago

Yes PLEASE! This would be super useful as often times (for us) the link is a giant and nasty expiring asset link to AWS or something and we want to use the cleaner filename as the anchor text.