Create external hyperlink with PSEXCEL ?

[SpeedBlack]

Hi,

Do you have a solution to create an external hyperlink with PSEXCEL ?

I tested :
$Worksheet.SetValue(1,1,'=LIEN_HYPERTEXTE("X:\XXX\XXX.docx";"TEXT")') --> OK, the expression writes the text but the hyperlink is not created.
$Worksheet.Hyperlinks.Add($Worksheet.Cells.Item(1,1),'"X:\XXX\XXX.docx","","","TEXT"') --> Nok

Have you got an idea ?

Thanks !

[RamblingCookieMonster]

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!

[SpeedBlack]

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 !