Forum Discussion

Jainsoumya's avatar
Jainsoumya
Contributor
3 years ago

how to open excel file using TestComplete

@Marsha_R I am not able to open excel file using this methd , though its is getting passed but required action is not taking place function ExcelExample() { // Get the sheet of the Excel file ...
Desktop Testing
Keyword Tests
Script Tests
Tested Applications
Jainsoumya's avatar
Jainsoumya
Contributor

Marsha_R  No action is taking place , script just got passed thats it.

AlexKaras's avatar
AlexKaras
Champion Level 3
3 years ago

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)

 

  • Jainsoumya's avatar
    Jainsoumya
    Contributor
    3 years ago

    AlexKaras 

    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");


    }