Hi i was wondering if I were to create a folder inside the project containing each excel file used in the “Data File” what would be the maximum of files I can have without compromising performance?
1.) The number of files doesn’t necessarily matter. What you would care about would be the total size of those files.
2.) This shouldn’t affect performance at all. The data would be on your hard disk.
Where I could see a performance impact would be working with a single, very large excel file. It would probably be a bit slow getting data from a file with 10k lines or more. But again, in terms of “how many files can I put in a folder?”, this won’t affect performance.