Refering to a variable in 'Excel Application scope not working"

[Rowley101]

Hello,
i am trying to read the “excelWorkbookName” from File explorer using ‘get full text’ activity, which is working, and then insert that into “Excel Application Scope” which is not. im not sure what i am doing wrong. here are a screenshot of my

1. Sequence
   
   

Im very intrested to see what i am doing wrong as everything looks okay and no spelling mistakes or anything like that.

workBook.GetSheets(0) Reads the first sheet in the workbook

[Rowley101]

P.S fileName is the path where the excel file is located. i.e. “c\User.…”

[Palaniyappan (Palaniyappan P)]

Hi
we can directly mention the file path of that excel in EXCEL APPLICATION SCOPE right
may i know why we do with get text activity
and even if we get from GET TEXT activity kindly check once with the value of variable filename like whether it has the right folder path

Cheers @Rowley101

[Luis261980 (Luis Nunes)]

Hi @Rowley101,

Read this topic

How to get the exact file names?

I am using UI path for my development. Have few clarifications below . I am trying to get the File name exactly from the path mentioned. Say for example, 3 pdf files are in “C:\users\kk\hi.pdf”, “C:\users\kk\welcome.pdf”, “C:\users\kk\readme.pdf”. I tried to get the PDF names using the foreach item after providing the path using “Directory.getfiles(selectedfolder)”. I am trying to get the file name exactly to pass for the next condition. like, i just need the names of it “hi.pdf”,“welcome.pdf”…

[vmariejeanne (Vincent Mariejeanne)]

HEllo,
You can process the 3 PDF in another way:

1. use the var1=directory.getfiles(LocalFolder)
2. use a foreach with for each item in var1 (Body → action).
   this will action to all pdf found in the LocalFolder one by one

Hope this will help.

Cheers,
Vincent

[Rowley101]

hi,
i am using the ‘get text’ Activity so that when there is a new file in the folder, everyday, it can read that text and use it in Excel application scope.
‘Filename’ is correct.
basically in excel scope the path should look like this:
“C:\Users\lurowley\PatientRecords\Dummy_Patients_20191008.xlsx”

and currently in the path it looks like:
fileName + excelWorkbookName + “.xlsx”
Where fileName: "C:\Users\lurowley\PatientRecords"
excelWorkbookName: “Dummy_Patients_20191008”

[bcorrea (Bruno Correa)]

Arent you just missing a \ after the fileName variable?

[Rowley101]

Hi everyone,

i have solved it.
used an assign activity

fileName = String.Join(“”, Directory.GetFiles(“folderPath", “*.xlsx”, SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) )

Thanks for the support