When working with a large excel file with 20+ columns, and we want to update only 2 of these columns, should we just read these two columns and then rewrite them, or should we read the whole excel file?
Best,
Charbel
When working with a large excel file with 20+ columns, and we want to update only 2 of these columns, should we just read these two columns and then rewrite them, or should we read the whole excel file?
Best,
Charbel
Hi
I believe both will work in same way and there won’t be a big difference in performance
If we read the whole excel or only one column any how we are going to process them in same way
To make it faster I would suggest to use linq query or if it has less number of rows then FOR EACH ROW activity with a assign activity inside will be completely fine
Go for complete excel
The reason is if you want to manipulate other columns or compare with other data along the process you don’t need to read the file again separately and process them
If we read it completely and have it as a global variable it can be used anywhere in the process and also to manipulate your required two columns alone
Cheers @Charbel1
Thank you very much @Palaniyappan,
But doesn’t reading 20+ more columns take too much time? (Also writing it again to update it)
Best,
Charbel
Well not really
I have used excel which has around 43 columns and it ran fine in just matter of minutes
greag
Is there any further queries on this topic
@Charbel1