Pdf file open

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

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…

step1 step2 step3

excel file pdf file

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!

Read PDF and Excel.xaml (7.5 KB)

@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

excel file pdf file


1 Like

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

@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

"Systemoutput file
pdf file open

1 Like

datatable how to convert as string… pls advise.

item is your pdf files right??

@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.

@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.

1 Like

you can go through this Post

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.