Forum Discussion
superuser
13 years agoOccasional Contributor
Hi Robert,
Thanks for your reply.
we have tried to close the driver as well but after some time the excel writing becomes slow by seeing the task manager. We are using Testcomplete 6 ver. The test complete popup stating "Unable to detech the test complete" is coming and stoping the execution.
here is the code
function writing_Excel(id_list,Id_array,Filename,start_combination)
{
var ecu_dummyarray=new Array()
var simFile_towrite=new Array()
for(m=0;m<ecu_array["length"];m++)
{
var str="";
ecu_dummy=ecu_array["split"]("_")
for(n=1;n<ecu_dummy["length"];n++)
{
str=str+ecu_dummy;
}
ecu_dummyarray= str
}
ECU_Final_Array=GUI_names(ecu_dummyarray)
var driver = Sys["OleObject"]("Excel.Application");
//Create_Status_Report_File()
var Handle = driver["Workbooks"]["Open"](GUI_STP_PATH);
driver = driver["ActiveWorkbook"]["Worksheets"]("System")
if(aqString["Contains"](SimFile,"CAN_",0,true) != -1)
{
detail=7
}
if(aqString["Contains"](SimFile,"DDL2_",0,true)!=-1 || aqString["Contains"](SimFile,"KWP_",0,true)!=-1)
{
detail=8
}
if(aqString["Contains"](SimFile,"DDL_",0,true)!=-1)
{
detail=9
}
simFile_towrite=SimFile["split"](".")
//ROW_NUMBER=Get_current_Row_index("VerificationDetails");
try
{
for(d=0;d<ECU_Final_Array["length"];d++)
{
if(d==0)
{
ROW_NUMBER=Get_current_Row_index_STP("System");
}
driver.Cells(ROW_NUMBER, 1) = VarToString(start_combination);
driver.Cells(ROW_NUMBER, 2) = ecuid_list;
driver.Cells(ROW_NUMBER, 3) = ECU_Final_Array;
driver.Cells(ROW_NUMBER, Sim_detail) = simFile_towrite[0];
ROW_NUMBER++;
//driver.Cells(ROW_NUMBER, TV4) = VarToString(topoversion4);
}
Handle["Save"];
Handle["Close"];
}
catch(exception)
{
Log["Error"]("Exception", exception["description"]);
}
}
Is there any way to close and driver in C++ scripting.
Thanks for your reply.
we have tried to close the driver as well but after some time the excel writing becomes slow by seeing the task manager. We are using Testcomplete 6 ver. The test complete popup stating "Unable to detech the test complete" is coming and stoping the execution.
here is the code
function writing_Excel(id_list,Id_array,Filename,start_combination)
{
var ecu_dummyarray=new Array()
var simFile_towrite=new Array()
for(m=0;m<ecu_array["length"];m++)
{
var str="";
ecu_dummy=ecu_array
for(n=1;n<ecu_dummy["length"];n++)
{
str=str+ecu_dummy
}
ecu_dummyarray
}
ECU_Final_Array=GUI_names(ecu_dummyarray)
var driver = Sys["OleObject"]("Excel.Application");
//Create_Status_Report_File()
var Handle = driver["Workbooks"]["Open"](GUI_STP_PATH);
driver = driver["ActiveWorkbook"]["Worksheets"]("System")
if(aqString["Contains"](SimFile,"CAN_",0,true) != -1)
{
detail=7
}
if(aqString["Contains"](SimFile,"DDL2_",0,true)!=-1 || aqString["Contains"](SimFile,"KWP_",0,true)!=-1)
{
detail=8
}
if(aqString["Contains"](SimFile,"DDL_",0,true)!=-1)
{
detail=9
}
simFile_towrite=SimFile["split"](".")
//ROW_NUMBER=Get_current_Row_index("VerificationDetails");
try
{
for(d=0;d<ECU_Final_Array["length"];d++)
{
if(d==0)
{
ROW_NUMBER=Get_current_Row_index_STP("System");
}
driver.Cells(ROW_NUMBER, 1) = VarToString(start_combination);
driver.Cells(ROW_NUMBER, 2) = ecuid_list
driver.Cells(ROW_NUMBER, 3) = ECU_Final_Array
driver.Cells(ROW_NUMBER, Sim_detail) = simFile_towrite[0];
ROW_NUMBER++;
//driver.Cells(ROW_NUMBER, TV4) = VarToString(topoversion4);
}
Handle["Save"];
Handle["Close"];
}
catch(exception)
{
Log["Error"]("Exception", exception["description"]);
}
}
Is there any way to close and driver in C++ scripting.