Automation writing #Name? instead of value

i am writing simply = or < 40 using write cell in excel

but when i am checking excel it is writing like name? like below

what is the issue?

Hi @Mathkar_kunal

You Can Assign in For Each loop

currentrow(“TestKey”).tostring=“= or <40”

It Helps

@Mathkar_kunal = or < 40 is not a valid Excel formula hence it comes back as #NAME?. Manually type in Excel first the formula you want and once that is working, copy that to the Write Cell activity.

Hope this helps!


Try this way


@Mathkar_kunal Use Apostrophe mark (‘) just before your string inside double quotes. You will get your desired output. While reading the value Apostrophe mark (’) will be ignored. Refer images.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.