i did a write cell to an excel file. my formula is from excel, textjoin formula.
“=TEXTJOIN(”+Chr(34)+","+Chr(34)+",TRUE,IF(F2 = F:F,T:T,"+Chr(34)+""+chr(34)+"))"
but when it comes to excel, @ sign was auto added in front of column F:F. which gave me wrong result. do you know why this happen? once i manually remove the @ sign, my result in excel is correct.
- i need to use TextJoin function to fulfil my requirement, note able to use concatenate.
- Chr(34) was to replace the double quote else uipath will show end of expression required.
appreciate any advise!