This project has moved. For the latest updates, please go here.

InsertData vs. Hyperlinks

Oct 10, 2013 at 2:54 PM
I Have a Collection of MyRow-Objects.
I am adding their data to my Worksheet like this:
ws.Cell("A2").InsertData(myRows);
so far so good!

One property of MyRow is an URL.
So how can i make it clickable?

i tried changing the Type of myRow.URL to XLHyperlink, didnt work.
i tried "http://test/" as the value for myRow.URL, didnt work.
i tried "{HYPERLINK("http:/test/"; "test")} as the value for myRow.URL, didnt work".

i also tried converting it after it was added to the worksheet like this:
ws.Column("K").FormulaA1 = ws.Cell("K1").Value as string; //{HYPERLINK("http:/test/"; "test")}

I am on Version 0.68.1.0!

Would be great if it can be done somehow without having to convert cell by cell.

Thanks!
keydon