Excel file is blocked

[ḥari]

Hi Team,
I have accessing datas from excel but suddenly I am getting error as "excel internal error 'element nit round" And "access to the excel file is blocked, possible because it is open in excel" But excel is closed.
Previously it's executed fine only suddenly it happens for current script which I am working.
May I know the possibility for this error?

[rraghvani]

There's most likely an instance of Excel running which is not visible - use Task Manager and kill the application.

[ḥari]

@rraghvani cleared everything but still same issue

[rraghvani]

How are you opening and closing Excel?

[ḥari]

I didn't open or close excel through script I just fetching datas from excel

[rraghvani]

How are you fetching the data?

[ḥari]

@rraghvani like this https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/exce...

[rraghvani]

Try and be more specific please. Are you using Excel object, DDTDriver object ?

[ḥari]

Excel objects only... It suddenly happened from yesterday onwards it's taking excel datas in between this error coming.

[rraghvani]

You are better off using Excel.Application COM object, as this will use the current version of Excel - providing you have it installed.

If you can provide code, which the error always occurs. Then I can try and diagnose the issue for you.