Forum Discussion
Folder.Files returns error when large file exists in a folder in Excel365
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
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.
2 Replies
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?
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.
