Forum Discussion

michaelzh17's avatar
michaelzh17
Occasional Contributor
8 years ago

Is Excel application installation a need for using of Excel driver?

Hi ,    I'm trying to do data - driven testing using excel file. I just find out the machine doesn't have office installed. Only thing it has is a excel viewer.  So can I still use Excel driver in ...
  • tristaanogre's avatar
    tristaanogre
    8 years ago

    I think if you're using the ACE driver, you need Excel installed.

     

    I think switching to CSV, though, is better anyways.  The files are more easily portable, you can actually do DIFF checking when putting them into source control a LOT easier, and you don't need a proprietary editor to edit the files.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

I think if you're using the ACE driver, you need Excel installed.

 

I think switching to CSV, though, is better anyways.  The files are more easily portable, you can actually do DIFF checking when putting them into source control a LOT easier, and you don't need a proprietary editor to edit the files.

michaelzh17's avatar
michaelzh17
Occasional Contributor
8 years ago

Thanks, Robert.

 

I'm working on csv now. But get error msg "Cannot update, database or object is read-only."

here is my code, pretty simple one, do you see any problem..

 

//code 

function test_csv(){

DDT.CSVDriver(Project.Variables.data_file);
while(!DDT.CurrentDriver.EOF())  // log error point to this line of code 
var sub_item = DDT.CurrentDriver.Value(0);

Log.Message(sub_item);
DDT.CurrentDriver.Next()


DDT.CloseDriver(DDT.CurrentDriver.Name);

}

 

Thanks,

Michael

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    Is Project.Variables.data_file a string containing the file name or is it the actual DBTable file itself?

     

    I tried the following:

     

    function testSomething() {
    DDT.CSVDriver(Project.Variables.dbTable);
    while (!DDT.CurrentDriver.EOF()) {
       Log.Message(DDT.CurrentDriver.Value(0));
       Log.Message(DDT.CurrentDriver.Value(1));  
       DDT.CurrentDriver.Next()     
    }
    DDT.CloseDriver(DDT.CurrentDriver.Name);
}


    Where the variable contains the string for my CSV file.  Note, I'm using a persistent variable but, so long as the variable contains a string, it works just fine.  So, I would double check and make sure that what you're passing as the Project.Variable.data_file is correct.

    • michaelzh17's avatar
      michaelzh17
      Occasional Contributor
      8 years ago

      Hi Robert, 

       

      Project.Variables.data_file has the address of the csv file. 

      I'm sorry, should be data_file_csv. After changed, the script just hang there when I try to run it...

      And as I read the document, I need to add a schema.ini file to pair with the csv file? I created that too...

       

      Maybe i should just use the file address directly in the script. 

       

      Michael

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        8 years ago
        michaelzh17 wrote:

        Hi Robert, 

         

        Project.Variables.data_file has the address of the csv file. 

        I'm sorry, should be data_file_csv. After changed, the script just hang there when I try to run it...

        And as I read the document, I need to add a schema.ini file to pair with the csv file? I created that too...

         

        Maybe i should just use the file address directly in the script. 

         

        Michael

        Looking at your screenshot, the file name in data_file_csv is missing the .csv file extension.  So, that may be why you're running into issues.

        As for schema.ini... you don't NEED to have it... it's useful to enforce data formats, etc., as they are read from the file as well as if you're not making the first row your column names allows you to define the column names.