CSV File Path from Excel Sheet
In my previous Question I asked abt the CSV Comparison.
Previously We are giving Static URL Path for the CSV's to Compare.
Now I dont how to get the path from the CSV File Sheet itself.
For Ex:
Sheet 1
Source URL Destination URL
C:\1st_File.CSV C:\2nd_File.CSV
If these are the path how to compare from this everytime to compare from Source CSV to Destination CSV
Once if this is Compared the Sheet must be
Sheet 1
Source URL Destination URL Result
C:\1st_File.CSV C:\2nd_File.CSV Passed
Once if this is not Compared the Sheet must be(File Not Found)
Sheet 1
Source URL Destination URL Result
C:\1st_File.CSV C:\2nd_File.CSV Not Passed
Kindly help me how to get the path dynamically from the CSV Sheet.
Thanks in advance