I want to add a whole lot of values to an Excel Spreadsheet.
What is the fastest way to do this?
And, what are my options?
The ones that I can think of are:
- Create a datatable with all my values in it and then add that to the spreadsheet using the write range activity.
- Writing a UiPath workflow that clicks and types into Excel mimicking exactly what a human user would do.
- Inputting the values individually using a loop and the write cell activity.
I would be interested I knowing what my other options are here.
Thanks.