dfilipovic
(Dino Filipović)
September 1, 2020, 7:12am
5
Hello @rebekka.haendel ,
you need to put an file path to your file like ‘c:\documents\test.xlsx’
But you can use Assign activity with Array of String to store all files in your folder with this command:
System.IO.Directory.GetFiles(“C:\documents”,“*.xlsx”)
Assign activvity:
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
After that you can use For Each loop to pass through every document in folder.
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
You can check couple of solutions:
Hi,
I want to extract only excel files and output it content
I try with following process
Main.xaml (23.9 KB)
this is my sample excel file
bb.xlsx (8.1 KB)
my problem is : when I run my process and jest second it stop
how I solve this problem
can you help me?
Hi Guys
I am trying to work how to read multiple excel spreadsheets of the same type in a folder and extract data from them. The problem is that the excel spreadsheets are converted into a form with radio buttons as values and text that also needs to be extracted So not sure how to read in the value. Is there any way of using a read range and extracting particular elements in the spreadsheet and storing it in variables to be used in further operations.
Hi,
I want to read 6 excel file from particular folder and write the same excel file in another folder.
Hello Community,
I need assistance. I have a folder and it’s in few excel file like Nancy_robot.xlsx, Angel_robot.xlsx. Now I want to open excel file one by one and select column C. Please any one can help me. That Will be best if you upload code.
Thanks
Cheers,
Dino