I am writing a datatable to csv file and later applying formula based on column values…
In order to apply formula. I had to use write cell…which can only be used within excel application scope.
So i opened my csv file using excel application scope and then applied formula using write cell method.
So far so good.
Now when i open the same csv file… all colums and its corresponding values are merged into single column.
I have further process to be applied on this csv file.
I know i can use text to data option of excel to separate the columns…but i was wondering if there is way to do the same using uipath?