This is indeed possible, you can export custom results of your
choosing to an Excel file. In the example below I have
exported some timer details of a testcase running against the
SilkTest Test Application.
Firstly you need to have the following code in a frame file and
call it CopyResultsToExcel.inc for example and then save it in
the desired location, in this case I saved it to the C: drive.
There is a version of this frame file attached to this
Note that I have created a custom TestCaseEnter and
TestCaseExit functions in order to create, start and stop the timer
for the test. This also assigns these values to the relevant
Next you need to create a blank Excel document and in this case
I called it Results.xls and saved it to the C: drive. You can see
the ConnectString for the Excel sheet at the top of the
CopyResultsToExcel.inc frame file. In this Excel file you need to
name the columns (top row of data) as the data that you wish to
export, in this case I am exporting "sDate, sScriptName,
sTestCaseName, sStartTime, sEndTime, sTime, sTesterName, sStatus
Finally you need to create a simple testcase and call the frame
file you created using the use statement.
Then when you run a testcase you will see that the Results.xls
file will get populated with the data you selected. In this case I
ran a number of tests, note that the Excel sheet gets appended so
the results are added one after another. As you can see I have also
included error handling in the TestCaseExit so that any error
message created in SilkTest are also exported to the Excel
I have attached a sample SilkTest project that runs against the
Test Application, an example of the Results.xls file and the
CopyResultsToExcel.inc frame file needed for your reference on how
to achieve this functionality.