Hi, has anyone ever done something like this: I have an Explorer folder with many Excel files. My desired process would have to output the number of rows with a certain value (e.g. “done”) from certain files with the same name range (e.g. Booking). Example: Booking001 with 10x done Booking002 w…

Hey @juergenh1975 Yes, it should be possible using UiPath Studio. Create a DirectoryInfo object to access the folder that contains the Excel files: DirectoryInfo = New System.IO.DirectoryInfo("C:\Your\Folder\Path\") Filter Excel files by Month: filteredFiles = directoryInfo.GetFiles("*.xlsx").W…

Count contents from different Excel files

Help Studio

juergenh1975 (Juergenh1975) November 11, 2024, 6:23am 3

Hi, many thanks ! I will test it tomorrow and then let you know

Topic		Replies	Views
How to save excel files with different names or number? + Additional questions Help excel , activities	10	2780	April 27, 2019
How can I read all .xlsx files in a folder and read tab names from each excel Studio excel , activities , studio	18	1743	September 17, 2022
How to count in each filter value in excel using uipath Help excel , uiautomation , studio , question	4	1309	February 17, 2020
Looping through all excel files in a folder Help	6	7327	August 2, 2019
How to read excel files using multiple files in folder Studio studio , question , activities_panel	5	67	September 23, 2024

Count contents from different Excel files

Related topics