Micro Focus QTP (UFT) Forums
Import Excel data from Quality Center into QTP Script - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Import Excel data from Quality Center into QTP Script (/Thread-Import-Excel-data-from-Quality-Center-into-QTP-Script)

Import Excel data from Quality Center into QTP Script - smilefouru - 02-17-2008

Hi,

I need help very very urgently,

How can I import excel from quality center folder path to QTP script?

I have written

datatable.Import ("[QualityCenter] Subject\FLIGHT_08\Data\Sample.xls") but i am getting error message path does not exist?

I want the above to be success using script but not thru tool provided settings?

Please Help me ASAP.....?

Thanks,
Ram

RE: Import Excel data from Quality Center into QTP Script - Ankur - 02-18-2008

First of all , please refrain from using the words like "very very urgently" , "ASAP". All members here are doing a voluntary activity of helping others, these words do nothing but to annoy them no end.

Now to your query,

This method requires the full path of your QC server and will not work with just the simplified path.

Try using DataTable.Import "//Path of your Quality Center server/...../Sample.xls"

RE: Import Excel data from Quality Center into QTP Script - davparveen - 04-15-2008

Hi

I tried importing excel data through this process but it gives me an error

The DataTable.Import (file) operation failed. Invalid file.

Line (6): "DataTable.Import "\\[QualityCenter] Subject\Automation Scripts\...\file.xls"".

PLease correct me if I have done some mistake in syntax...
if syntax is right then please tell me how to do that......

RE: Import Excel data from Quality Center into QTP Script - niranjan - 04-15-2008

Try using QCUtil object..
Something like below...
Code:
Set tdc = QCUtil.QCConnection
set tm = tdc.TreeManager
set root = tm.TreeRoot("Subject")
set folder = root.FindChildNode("Your folder name")
Set fact = folder.Attachments
and so on...

RE: Import Excel data from Quality Center into QTP Script - Johny Kluge - 08-18-2008

Hi,

I am trying yours answer again and again, but with no result Sad

Is this syntax correct?

datatable.Import ("//mercurytd.com:8003/qcbin/Subject/TestFolder/Book2.xls")

Does the path need to be to MQC Test Plan > Test Folder > Test attachement > name of attachement???
Or to module Test Lab???


Thank you
J.

RE: Import Excel data from Quality Center into QTP Script - axl_rose08 - 04-02-2012

I have the same problem, could anybody help me? Sad

Thanks in advance.

RE: Import Excel data from Quality Center into QTP Script - sshukla12 - 04-03-2012

Hi,

Use the below code it might help u.
Make changes for QC test paln folder structure.

Code:
Function ImportDataSheet(strsheet)
   Dim sheet_name
   sheet_name=DataTable.LocalSheet.Name
   Call Import_ressources("Subject\97_RTT Resources","TestData","DataSheet.xls",strsheet,sheet_name)
End Function

Function Import_ressources (parent_folder, proj_name, src_file, src_sheet, dest_sheet)

Import_ressources = false

Set objTreeManager = QCUtil.TDConnection.TreeManager
Set projNode = objTreeManager.NodeByPath(parent_folder)

'  projNode.Count = nombre de REPs trouvés
For i = 1 to projNode.Count
  '  Le sous_dossier a été trouvé
  If instr (1, projNode.Child(i).Name,  proj_name) > 0 Then
   Set projNode = projNode.Child(i)
   Exit For
  End If
     Next
wait(2)
' Recherche du fichier paramètres (attaché)  
Set res = projNode.Attachments.NewList("")
For Each attach In res
  If Not Instr(1 , attach.FileName , src_file) = 0 Then
   attach.Load True, "C:\"
            datatable.AddSheet (dest_sheet )
   ' REM : 1 --> première feuille dans le fichier XLS
    DataTable.ImportSheet attach.FileName, src_sheet, dest_sheet
   'DataTable.ImportSheet attach.FileName, 1, dest_sheet
   Import_ressources = true
  End If
Next
wait(2)
End Function



Regards,
Sankalp