You can refer to "Microsoft Excel 2000 Visual Basic for Applications object model" for a complete listing of Excel methods and properties that can be used within a QuickTest Professional (QTP) script. You can use these Excel object methods within a QTP script to create workbooks, create new sheets, input data, etc.
For a complete listing of Excel object's methods and properties, refer to MSDN Library - Microsoft Excel Object Model (http://msdn.microsoft.com/library/de...pplication.asp).
The following is a sub-procedure that uses Excel object methods to output data from a dictionary object to an Excel file. Attached you will find a working example of a QuickTest Professional test that uses the sub-procedure below. The example will retrieve information from a webpage and output it to an Excel file (info.xls) using the ReportInformation sub-procedure.
In order to run the test, unzip the attached file to a temporary folder, and start QTP with web support loaded:
CPT31467.zip
Example:
Sub ReportInformation(dictionary, filename)
' create the Excel object
Set ExcelObj = CreateObject("Excel.Application")

' add a new Workbooks and a new Sheet
ExcelObj.Workbooks.Add

Set NewSheet = ExcelObj.Sheets.Item(1)
NewSheet.Name = "Page Information"

' loop through all the information in the Dictionary object
' and report it to the Excel sheet
row = 1

For Each key In dictionary.keys
NewSheet.Cells(row,1) = key
NewSheet.Cells(row,2) = dictionary(key)
row = row + 1
Next

' customize the Sheet layout
NewSheet.Columns("A:A").ColumnWidth = 20
NewSheet.Columns("A:A").Font.Bold = True
NewSheet.Columns("B:B").ColumnWidth = 60
NewSheet.Columns("B:B").HorizontalAlignment = -4108 ' xlCenter

' save the Excel file
ExcelObj.ActiveWorkbook.SaveAs filename

' close the application and clean the object
ExcelObj.Quit
Set ExcelObj = Nothing
End Sub