Ask a Question

Script to verify DB Table workbook

SOLVED
Larry_M
New Contributor

Script to verify DB Table workbook

Hello,

 

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,

Larry

1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

Re: Script to verify DB Table workbook

1 REPLY 1
Marsha_R
Community Hero

Re: Script to verify DB Table workbook

cancel
Showing results for 
Search instead for 
Did you mean: