Forum Discussion
Marsha_R No action is taking place , script just got passed thats it.
- Marsha_R2 years agoChampion Level 3
Your syntax is correct, so I would first look for an issue with file permissions. Make sure that TestComplete has access to that particular directory. You could try putting the Excel file on the desktop to begin with, just to confirm the permissions.
- Jainsoumya2 years agoContributor
Marsha_R I have tried this but no result , script got passed but no required action took place
- AlexKaras2 years agoChampion Level 3
Hi,
> No action is taking place
What action do you expect?
Note, that Excel object provided by TestComplete does not require Excel application to be installed and thus does not provide any UI.
If you need to open the file in Excel application, then you must start Excel as a COM object and use its object model. (https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/working-via-com.html as an example)
- Jainsoumya2 years agoContributor
I have tried this two methods and script got passed but required excel file didnt get open
function ReadDataFromExcel()
{
let Excel1 = Sys.OleObject("Excel.Application");
Excel1.Workbooks.Open("C:\\Users\\Public\\TestInput\\ChartInput.xlsx");
}and
function ReadDataFromExcel()
{
let Excel = getActiveXObject("Excel.Application");
Excel.Workbooks.Open("C:\\Users\\Public\\TestInput\\ChartInput.xlsx");
}