Forum Discussion
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)
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");
}
Related Content
- 6 years ago