Excel Error #NAME? / Write Cell

[melanie.schlenk]

Hello, I’m trying to enter an IF function to my Excel file with “Write Cell”, but I always get the error name?
If I click in the cell and click enter, the function is correct.

So how can I solve the problem or is there a function I can use, that the RPA will click in each cell and click into it and click enter.

I’m using the function in German. The semicolon is already changed into a comma.

[jose.ordonez1 (Jose Ordonez)]

Hi @melanie.schlenk,

Please try to use the following expression, using an IF condition.

if (DataTable.Rows[rowIndex][columnIndex] != null) { /* code for when the cell is not null */ } else { /* code for when the cell is null */ }

Anoher way to do that:

if (condition)
{
    DataTable.Rows[rowIndex][columnIndex] = value;
}

Hope it helps you!

[ashokkarale]

Hi @melanie.schlenk ,

Welcome to the UiPath Community!

Probably there is something wrong with your formula passing to the cell logic. You can share it if my solution doesn’t help.

Pass the formula in string format like mentioned in the code. It will defiantly reflect as expected.

Thanks,
Ashok

[Yoichi]

Hi,

If you try to input IF function as non-English language such as Spanish, can you try to input it as English like =IF(....?

Regards,

[melanie.schlenk]

Thank you.
I changed the formula from German WENN to English IF and it worked.