Write formulas to Excel with "Append row to Excel" nodo

[Miguel_in]

Describe the problem/error/question

Hi guys,

I have an “Append row to Excel” nodo which adds a row to an excel in Office 365. It is wriring all columns perfectly except a cell containing a formula. The formula used is an "=Hyperlink("URL;“Link” so it is quite simple.

If I paste same content that I have in the nodo directly on the cell, it shows the link perfectly but once it is writeen by the node, it is shoen as text, showing all the formula. Cell is formatted as General.

Share the output returned by the last node

This is the outputo for that field (in spanish codification)

=HIPERVINCULO(“\server\facturas\202503_ AMAZON.pdf”;“Abrir factura”)

[Prashant_Kumar_Singh]

I wanted to clarify a few things:

1. Are you using the native Microsoft Excel node, or are you handling Excel through a custom script or HTTP reques?
2. Is your Excel file stored on OneDrive, SharePoint, or somewhere else (like a local or network drive)?
3. How exactly are you formatting the formula in the node input? (For example, are you manually escaping special characters or using double quotes?)
4. Do you expect the cell to display a clickable hyperlink, or is plain text with the URL also okay?

[Miguel_in]

Hi guy,

THanks for the reply.

Regardin questions:

1.- I am using the native Microsoft Excel 365 node.
2.- It is stored in OneDrive. It does not allow to work with “local files”.
3.- The format given is: {{ ‘=HIPERVINCULO("’ + ‘\\192.168.1.15\facturas\’ + $json[“nombreArchivo”] + ‘",“Abrir factura”)’ }} so it appears as text in this format in Excel: =HIPERVINCULO(“\192.168.1.105\facturas\invoice.pdf”,“Abrir factura”)
4.- I am looking for this behaviour:

but I see this: