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.

Krishna_Kumar's avatar
Krishna_Kumar
Contributor

TanyaYatskovska ,

 

from project suite variable (Table variable).

 

Kind Regards,

Sathish Kumar K

tristaanogre's avatar
tristaanogre
Esteemed Contributor
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.

  • Krishna_Kumar's avatar
    Krishna_Kumar
    Contributor
    6 years ago

    tristaanogre ,

     

    Thank you very much for your help.

     

    Kind Regards,

    Sathish Kumar K