Excel Application Scope name excel file

[rebekka.haendel]

Hi everyone,

I am about to learn how to work with UiPath and I am wondering how to automate the following example:
In every Excel Application Scope a Workbook bath has to be filled in.
Every time to robot is running i´d like to have the results stored in a different Excel File.
Is there a way to somehow name the workbook path or something else so that it works with a new Excel File?

Thank you for your help,

Rebekka

[Udhay (Udhayanidhi Natarajan)]

Hi @rebekka.haendel,

You can use variable in the filepath of Excel application scope.
If you need to change the path for each run, then you can keep the value in config or asset.
If it needs to be changed for each iteration during a run, then you can update the value of variable for each iteration.
Hope this helps!
Happy coding!

[Sahil_Garg]

Dear rebekka

u means u want to have data of excel file in other excel file
First use excel scope and use read range and store whole excel data in a dataTable variable
second use another excel Scope with path defined and then use write range activity.

Hope this will help u

Thanks
Sahil

[rebekka.haendel]

Hi @Udhay,

Thank you for your respond.
Thought about using a variable as well.
What exactly would I have to put in the filepath of Excel application scope?

[dfilipovic (Dino Filipović)]

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:
https://docs.uipath.com/activities/lang-en/docs/assign

After that you can use For Each loop to pass through every document in folder.

https://docs.uipath.com/activities/lang-en/docs/for-each

You can check couple of solutions:

Choose only excel file

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?

How to read multiple excel spreadsheets in a folder and extract data from them

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.

How to read all the excel file from a particular folder?

Hi, I want to read 6 excel file from particular folder and write the same excel file in another folder.

How to open excel file one by one in a 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

[rebekka.haendel]

Hello @dfilipovic,

Thank you for your time and great help.

To make things clear: the following command ist what I need to type into the Workbook path of Excel Application Scope? System.IO.Directory.GetFiles(“C:\documents”,“*.xlsx”)

I get erros with that.

Cheers,
Rebekka

[dfilipovic (Dino Filipović)]

Hi @rebekka.haendel,
you can find my solution to your problem here in zip document:
OpenMultipleExcel.zip (48.0 KB)

Cheers,
Dino

[Imran_Khan2 (Imran Khan)]

Dear Good Evening ,

i use your zipfolder and try to run the same file in my pc , but while running process i got same error

Excel Application Scope: Error opening workbook. Make sure Excel is installed.

uipath not recognized excel in my pc , what should i do now

refer my path :

“C:\Users\USER\OneDrive\Documents\UiPath\Excel Activity.xlsx”