'When i write a formula in excel using xlwings it makes a @
I'm trying to find all the UNIQUE numbers of a column, but when i use the Excel function UNIQUE Excel makes a @ infront. I use xlwings, and have used (if, sum, average) function without any problems.
sheet.range('X1').value = ['=UNIQUE(A:A,FALSE,FALSE)']
Then excel writes it as: =@UNIQUE(A:A;FALSE;FALSE)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|