Issue inserting Excel formulas from Config file in UiPath

[Ben.Zineb]

Hello community,

I am trying to insert specific formulas into an Excel file (from cells N2 to Z2) using UiPath.

I stored the formulas in the Config file and used them in my sequence (please see the attached screenshots).

However, instead of inserting the actual formulas, the robot writes “TableName” into the cells.
Has anyone experienced this issue before?
Do you know what might be causing this behavior?
Thank you in advance.

[prashant1603765 (Prashant Kumar)]

Hi @Ben.Zineb

Pls check -

• Your formula contains curly braces {} or quotes in a way that makes UiPath treat it as a literal string.
• You passed the formula inside double quotes in the Config, so Excel receives it as plain text.

Or Just debug- check all formula directly using write cell , if work then use through config .

Happy Automation

[ashokkarale]

@Ben.Zineb

Could you please share the formula you are using?

[Ben.Zineb]

[MrBidstrup (Lasse Hoffmann Bidstrup)]

Hi
@Ben.Zineb Could you try to remove the double quotes in the config file and then just in the start set a single Quote?

That works for me

[ashokkarale]

@Ben.Zineb

Replace the one double quote with two like “”. Inshort escape it.

[Ben.Zineb]

Hi,
Thank you for your response, but it not worked

[Ben.Zineb]

Hello,
Thank you for your response, but it not worked

[MrBidstrup (Lasse Hoffmann Bidstrup)]

Hmm how to you write it to the Excel?

I use a for each with a Write Cell. Do you get an error or do you get the same as before?

[Ben.Zineb]

Hi,
Thank you for your response.
I want to write this formulas.

[MrBidstrup (Lasse Hoffmann Bidstrup)]

Add Formula to Excel.zip (464.5 KB)

Hi @Ben.Zineb

Please try to see the code I attached. (Hope I’m allowed to share code here in chat)

[UBur (Uwe Burow)]

The word TableName is the result of dtFormulas.ToString. You use it in the FillRange activity.

[Ben.Zineb]

This solution worked. Thank you very much!