Forum Discussion

Larry_M's avatar
New Contributor
3 years ago

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,