| || |
How to download Summary grapg from QC to excel
I was trying to capture the reports from quality center to excel sheet using graph object. I was able to capture the graph but unable to copy it and save it to the excel sheet.
Please help me regading this. Below is the code i have used :
Set tdc = QCUtil.QCConnection
'Set BugFact = tdc.BugFactory
'Set BugFilter = BugFact.Filter
' Set graph1 = BugFact.BuildSummaryGraph("TS_STATUS", "TS_SUBJECT", "", 0, BugFilter, False, true)
' MsgBox graph1.ColCount
' MsgBox graph1.GraphTotal
' MsgBox graph1.MaxValue
' MsgBox graph1.RowCount
it is displaying all the values correctly. but how to capture it?....