Deal with hyperlinks

[jennybc]

Consider a cell that holds a hyperlink. Currently we just import the link text, unless we get full cell data. Figure out if there's some intermediate that makes it easier to get the URLs. Need to also investigate the case of cell text that is only partially a hyperlink.

[allenbaron]

I would also like to be able to write hyperlinks to google sheets.

[MichaelChirico]

Ditto! Is there any known workaround to writing hyperlinks to sheets? Wrapping the text as <a href="{URL}">{URL}</a> didn't help, e.g.

[jennybc]

I think I really have to implement hyperlinks properly to get this (?). I don't personally know of a workaround off the top of my head.

[MichaelChirico]

At least for writing, it looks like =HYPERLINK("{URL}") is the way to link a cell... unfortunately write_sheet() escapes it by prepending '

[jennybc]

I can't test this myself right now, but maybe try writing that as a formula.

https://googlesheets4.tidyverse.org/articles/write-sheets.html#write-formulas

[MichaelChirico]

Ah that's wonderful! Thanks!!! Solves my issue, which is narrower than that of this issue overall.

[benyamindsmith]

I would like this feature to also be available to read a google sheet data with hyperlinks and write it to other sheets with them.