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  ...
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.