# How to get hyperlink in a formula using EPPlus

 Refresh April 2019 Views 12 time
0

I need to get the exact link inside the formula(HYPERLINK) and save it to the database. here is my code to get the link,

  answerList.Add(new SurveyCompetitorAnswer
{
MainSurveyId = id,
DateCreated = DateTime.Now,
SurveyQuestionId = item.Id,
SurveyCompetitorId = comp.Id
});


but it get the whole FORMULA text. example (HYPERLINK("https://www.owler.com/company/sproutsolutions","0.5"))

...

what I need is just https://www.owler.com/company/sproutsolutions.

I tried using Link = workSheet.Cells[AnswerRowRange].Hyperlink, but its purpose is only to SET links and not GET links.