Forum Discussion

harry_pbi's avatar
harry_pbi
Frequent Visitor
3 years ago
Solved

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 t...
Need Help
  • harry_pbi's avatar
    harry_pbi
    3 years ago

    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. 

ToddChitt's avatar
ToddChitt
Super User
3 years ago

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's avatar
harry_pbi
Frequent Visitor
3 years ago

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.