Create external hyperlink with PSEXCEL ? about psexcel HOT 2 OPEN

Hi!

Not currently, but, it looks like EPPlus (the library we use) does support setting a hyperlink

Only problem is, I don't know if a regex can truly capture whether we should hyperlink a cell. If we find a link in the text? What if there's more than one? Is there really a regex that can capture any format of link, without false positives? etc.

Could potentially be added to Format-Cell, but you would need to have code that says "I want this cell to have this hyperlink," or something along those lines (you could likely come up with a regex that fits your needs specifically)

Timing wise, this might take a while - Have a conference talk coming up, holidays, decompress, etc, and PSExcel is already on the back burner (trying to encourage folks to use ImportExcel) - Ping me in February if you don't hear back - if you want to try tackling it yourself for a pull request, this might get you started

Sorry to be a pain!

Cheers!

from psexcel.

Hi RamblingCookieMonster !

I am sorry not to have been able to get back to you sooner.

Ok, no problem !
Thank you very much for the splendid job done with PSEXCEL !

from psexcel.