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
6 years ago

Hi TanyaYatskovska  and tristaanogre ,

 

Thank you very much.

i was able to export the data table values to an external excel successfully by using the ole object concepts.

But it would be good if you provide information about how to retrive the datatable column names, because i am able to retrive only the column values.

waiting for your response.

 

Kind Regards,

Sathish Kumar K

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago

    Column names from where? from an Excel file?

    • Krishna_Kumar's avatar
      Krishna_Kumar
      Contributor
      6 years ago

      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.