Folder.Files returns error when large file exists in a folder in Excel365

[harry_pbi]

Hi,

how can I read list of large csv files in a folder in Excel365? Currently am I using Folder.Files however the "Content" column of Binary data type can't handle large files in a folder (greater than 50-100MB).

Thank you for your help.

harry

[ToddChitt]

Can it read ONE of the files? Like if you target a single CSV file, will it discover the meta-data in the file? Is there a way to trurn off scanning of the file to do discovery?

[harry_pbi · Accepted solution]

Can it read ONE of the files?

>>no

Like if you target a single CSV file, will it discover the meta-data in the file?

>>no

Is there a way to trurn off scanning of the file to do discovery?

>>no in my opinion, but not sure

However I found out, that Folder.Contents does what I need. Weird, both functions have the same structure of output but Folder.Files has problem with large files.