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
Marsha_R No action is taking place , script just got passed thats it.
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.
Marsha_R I have tried this but no result , script got passed but no required action took place
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");
}
