Loop for excels in a folder

[ppr (Peter Preuss)]

@ymshin0421

to make a loop for excels in a folder?

• for each file in folder Activity - feel free to set a filter for e.g. exlsx files

OR

.Net Statement:

• Directory.GetFiles
• New DirectoryInfo(“YourPath”).GetFiles(…

[CheatSheet] - Filesystem APIs

This CheatSheet introduces the basic use of available functionalities provided by the .Net API in order to deal with the filesystem. With further examples also special cases are presented. Basic Usage System.IO.Directory Directory offers some static methods for basic operations on folder and subfolders arrFullFilePaths | String() = Directory.GetFiles("C:\_demo\FileSystem\SubfolderA") Visuals System.IO.DirectoryInfo The DirectoryInfo class offers instance methods for basic operations on fol…

UPD1 - Visualizations