Hi Guys,
I am generating an Excel file and i am setting the following EXCEL function as a value for Cell_Write action:
"=HYPERLINK(""URL"";""Map Location"")"
Unfortunately, this conversion is not working. When the file is generated the function is not being converted into a function itself and it's considered a string!
I have tried to perform the Worksheet_Calculate but no luck with that.
Is it possible to do this?
Cheers,
Pedro Domingues
Hi Pedro
Did you perhaps set the CellType parameter to "function"?
Hanno
Just a follow-up - I tried my suggestion and it doesn't work.
I'll have to dig into the details of EPPlus to see if we can make it work.
Hi Hanno,
I really appreciate your help!