Importing a Column from the excel sheet to Local sheet in QTP
I have an excel sheet saved at a particular destination(this destination is mapped to a network drive). I need to log into this destination (to a particular folder) and check for the file i saved and open that particular excel and need to import only a particular column (say, column 'o') of that sheet to local sheet of my script in QTP. How do i do this? Is there a method where i can import only a particular column into the Local Sheet at the runtime and then compare this with another file (say, xml file)? Your help in this regard, will be much helpful...
Thanks in advance.