Best Practices on dealing with large excel files

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

1 Like

Well not really
I have used excel which has around 43 columns and it ran fine in just matter of minutes

@Charbel1

1 Like

greag

Is there any further queries on this topic
@Charbel1