Ask a Question

Script to verify DB Table workbook

New Contributor

Script to verify DB Table workbook



I'd like to verify that the DB Table project variables, of type Excel, are actually present on the file system. If a file is not present, I'm going to provide a friendly error message in the log and terminate the test.


I have a script that iterates over the project variables and checks for type 'DB Table'. I'm stuck trying to determine if the variable is for an Excel file and if it is, the workbook path + filename. In the project's Temporary Variables tab, the column labeled "Default Value" contains the data I want but the Project.Variables.GetVariableDefaultValue() method only seems to return a ColumnCount value, unfortunately.

Any pointers to TC API docs or examples is greatly appreciated.


Thanks in advance,


Community Hero

If the method is not working like these examples


then you should contact Support directly

[Community Hero]
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
Showing results for 
Search instead for 
Did you mean: