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