Is the Write Value activity the fastest way to write formulas in Excel sheets?
I’m asking you this because as far as I know when we are using this activity, we need to iterate between the excel rows in order to fulfill each row with the proper Excel formula, which means that it takes some time if the excel sheet contains too many rows (an average of 1 second per row, to write a new formula on a specific column).
If I use the Write Range activity, is there a way to accept formulas while working with Data Table?
I’m asking it, because when we use the Write Range activity and I define a column with a formula, it actually doesn’t respect the formula and it write it as a String. The column will just contains the string from this formula and not the value that was expected from the formula itself.
Here we have a basic example when I’m using the Write Range activity.
I’m just changing the row number from the formula and I know that in this case I could make the calculation right into the UIPath workflow, but imagine the same scenario with more complex formulas. If you have any better ideas, please let us know.
Thanks and Regards,