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…
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
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
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.
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
Ukesh Kumar D
Main.xaml (13.5 KB) toPrintTheDownloadedAttachment.xaml (59.9 KB)
you can go through this
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.