Hello there! First post here.
I’ve used Table Extraction from a website to get some raw data, it automatically saves the data into a new DataTable variable. Then, I use write range to save into an excel file. Everything is fine until I open the file. I get something like this:
I would like to somehow format the data so that Excel can automatically read as some numeric type, and not as String. For some columns I know I have to change DataType columns as Integer or Double, when there is only the number on the cell. But I would like to represent, for example, the “$” values as cash in Excel, and not as text (General format), but I don’t find the way to do it in UiPath, and I really like to avoid UiAutomation.
Same for cells with “%”, M, K (at the end of the number and add the correct amount of 0’s).
Thanks in advance! <3