But it doesn’t work, I have an excel exception.
I tried to replace the semicolons by commas (I read it on a topic) but it doesn’t work.
Knowing that the formula works when I write it manually in Excel.
Thanks
How do you remove it exactly ?
You mean, use a first write cell activity to write the formula with an apostrophe, then use another activity to write it again without the aopostrophe this time ?
To make it simple, I have my main excel sheet, in which I have a column with postal codes (the first two digits of the code represent the department, hence the “GAUCHE” (means LEFT) function in the formula.
I have another excel sheet with department numbers associated with a person, like this:
In the main sheet I have to retrieve the person corresponding to the postal code, then sort the sheet by person. And if the search doesn’t find anything, I write “INDISP” in the cell
Fine! That works well, thank you
My formula syntax was incompatible with UIpath?
Otherwise, I have a last question concerning the sorting. Is there any way to use the sorting capabilities of Excel? Or do I have to read my sheet, sort the datatable and then write the table in Excel ?
I have an error “no compiled code to run”
I I have never used the invoke code activity, I’m not sure how it works.
I just replaced the arguments to match my excel workbook