[Advanced Excel] Generate Excel with Functions
excel-png
Service icon
Forge component by Carlos Freitas
Application Type
Traditional Web, Reactive

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

mvp_badge
MVP

Hi Pedro

Did you perhaps set the CellType parameter to "function"?

Hanno

mvp_badge
MVP

Hi Pedro

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.

Hanno

Hi Hanno,

I really appreciate your help!

Cheers,

Guys I have the same issue need help

Hi,

For the CellType, please use "formula" instead of "function".

It can work for me.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.