How do QTP access the cell values in an excel file located in QC.

[Faisalalik]

Hi

Is it possible to retrieve cell value directly from .xls file located in Quality Center using QTP. I do not want to import the excel file rather need to fetch the cell values directly. e.g

Set objexl = Createobject ("Excel.Application")
set wbook = objexl.workbooks.open "path of excel file"
set wsheet = objexl.worksheets(1)

value=wsheet.cells(1,2).value

This code will fetch the cell(1,2) value, when i access local excel sheet ie. located at a given path in my system.

Now the scenario is that the excel file is located in QC and i need to fetch the cell values in a same way as above using QTP.

Please note i don't need to import an excel file from QC.

Thanks
Faisal

[Anshoo_Arora]

I have never tried what you have mentioned here, however, there is a way to retrieve the attachment and I can help you with that. You can get the specified data from that file after the attachment has been downloaded. I haven't yet felt the need to try it though; I like to keep things pretty simple.. let me know..