Forum Discussion

DurgaPrasad's avatar
DurgaPrasad
Occasional Contributor
11 years ago

Problem with Excel ACE driver Setting

Hi,

I am using DDT.ExcelDriver for reading excel spread sheet.

i need first row as data row and all cells should be text.

I did exactly as in the following link given by Testcomplete 



http://support.smartbear.com/viewarticle/56928/



but it is not working for me.

So could any one please help me out.

I am using TestComplete Licensed 8.7 version and using windows 7 for test run .



Thanks and Regards,

durga

2 Replies

Sort By
  • AlexKaras's avatar
    AlexKaras
    Champion Level 3
    11 years ago
    Hi Durga,



    The more information you provide about what exactly does not work, the more chances that people will be able to help you...
  • DurgaPrasad's avatar
    DurgaPrasad
    Occasional Contributor
    11 years ago
    Hi Alex,



    Thanks for guiding me.



    i had the following code

    i=0;

    //Reading of Excel Sheet



    ExcelSheetReader = DDT.ExcelDriver(spreadSheet, workSheet,true);        


    ExcelSheetReader.Name=workSheet;        

    ProjectSuite.Variables.ExcelSheetsCount=++i;  //loop for different work sheets



     next 

    i read the ExcelSheetReader into array.



    Now

    In my excel sheet i have cells which are greater than 256 characters and i want first row to be read as data row. hence 

    i used ace driver as i placed true in the ExcelDriver() function .



    I followed the instructions as given by TestComplete 

    The settings for the Excel ACE driver are specified by the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel key. 

    and defined     FirstRowHasNames subkey 

    but still i am not able to read the excelsheet header as data row.

    also i am facing truncation problem for rows > 8  which i don't  want.

    so could any one please help me out.



    thanks and regards,

    Durga,

    Quality Control.