Forum Discussion

Krishna_Kumar's avatar
Krishna_Kumar
Contributor
6 years ago

Export Data Table values to External File

Hi Team,   i wanted to export the data table values to an external CSV file or excel file programatically after each and every execution. im using vbscript. can anyone help me on this ?   K...
  • tristaanogre's avatar
    tristaanogre
    6 years ago

    A table variable has two properties/methods: ColumnCount and ColumnName.  ColumnName has a parameter for the index of the column, 0 based.  So Project.Variables.tableVar.ColumnName(0) will return the column name of the first column in the table.  Using ColumnCount, you could build a for-loop to iterate through the columns and document the names.