Pdf file open

[Raj_Nadar (Raj_Developer)]

I need to read the excel file and and open pdf with the same

Excel file under sheet1 : airtel bill Jun (row 2)
airtel bill July (row 3)

pdf folder : airtel bill jun.pdf
airtel bill July.pdf
airtel bill Aug.pdf

if excel file name match with pdf file name then open and click the tab and close application

[Raj_Nadar (Raj_Developer)]

It will match first file in excel and first file in pdf… giving output in IF Condition which was wrong?

I want read excel file if the same name available in pdf folder then open the pdf file and do…

[Raj_Nadar (Raj_Developer)]

[Pradeep_Shiv]

Hello @Raj_Nadar,

I’ve developed, what you are looking for please try it out and let me know if it’s works out for you!

Cheers
Read PDF and Excel.xaml (7.5 KB)

[Raj_Nadar (Raj_Developer)]

@Pradeep_Shiv - Its working fine… as read range i put 2 rows need to read It will execute 2 times as output coming 6 times,do you have idea about this?

inputs : 2 excel file
3 pdf file

[Pradeep_Shiv]

First you can merge both the datatable and you can give a try!
@Raj_Nadar

[Raj_Nadar (Raj_Developer)]

@Pradeep_Shiv Got it… i try to open pdf… if condition is met… but getting error application not

writeline i pass the message as : row.tostring … output would be “system.data.datarow” ideally it should be filename.pdf

"System

[Raj_Nadar (Raj_Developer)]

datatable how to convert as string… pls advise.

[Pradeep_Shiv]

item is your pdf files right??
@Raj_Nadar

[SenzoD (Senzo Dlomo)]

@Raj_Nadar, My suggestion is:

read the excel file and use the Path.GetFile() to assign an array variable of the list of all files, then use an if activity to compare the name of the file you got from excel with the list of files in the folder, if you find a match send hotkey with Ctrl + R + Enter to start CMD and paste the full path and file name with extension + Enter, then the file will be opened.

[Raj_Nadar (Raj_Developer)]

@Pradeep_Shiv - thanks for helping out… I tried to give print using "invoke power shell as getting error.

I do not want use Hotkeys, please suggest.

[Pradeep_Shiv]

Add File into Printer Queue using uipath

Hi, I’m trying to add a file to a specific printer queue to print the file. But unable to succeed in that. while executing it, job are being added in spool status and gone in faction of second. Can anyone able to help me out? I have upload my flow aswell Thanks, Ukesh Kumar DMain.xaml (13.5 KB) toPrintTheDownloadedAttachment.xaml (59.9 KB)

you can go through this Post