Only checking in with the best practice on using these activities:
- seeing they are giving me the same output and format.
- But different processing speeds
I tested a sample sheet on my side on 2061 rows, here is my result:
I want to use the File–> Workbook Activity as it read and writes in 4 sec for 2061 rows.
Workbook - this will not open excel as application …it tries to read the data from excel file directly from backend…so would be faster for reading and writing.It does not need excel application to be installed
Classic/modern - both the functionality is same…modern has a different layout and more options…both will need excel application to be installed and will open the excel in the application only
Hope this helps
Then best to use “Workbook” and “Data table” activities as much as possible.
Only when other Excel process is needed besides reading and writing, then use Modern/Classic.
Thanks, I’m trying to be efficient in my flows.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.