Excel file is blocked

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.

Maybe add a step at the beginning of your script to close all Excel instances to be sure you have nothing to interfere during your actual test steps dealing with Excel.

//
// Close all excel instances
function closeExcelInstances()
{
var childcounts = Sys.ChildCount;
for(var count=0; count<childcounts; count++)
{
if(Sys.WaitProcess("Excel", 0).Exists == true)
{
var processcount = count + 1;
Sys.Process("Excel").Terminate();
Log.Message("Excel processs count: " +processcount+ " successfully closed");
Sys.Refresh();
childcounts = Sys.ChildCount;
count=0;
}
}
return;
}

=============

var ExcelFilePath = ""+Sys.OSInfo.TempDirectory+""+excelfile+"";
var SheetName = "Sheet1";

// Open the above Excel file through Sys.OleObject
var MsExcel = Sys.OleObject("Excel.Application", "");

MsExcel.Workbooks.Open(ExcelFilePath);

var Sheet = MsExcel.Sheets.Item(SheetName);

.

.

// Close Sys.OleObject for Excel application
MsExcel.Quit();
Delay(1000);

// Select 'No/Don't Save' button
selectMicrosoftExcelInfoDontSaveBtn();

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

How are you opening and closing Excel?

How are you fetching the data?

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

If you can create a sample project, which reproduces the issue, then I can have a look. Other than that, it's not possible without looking at the code.

Neither of these statements "excel internal error 'element nit round" and "access to the excel file is blocked, possible because it is open in excel" are standard error messages.

Are you able to provide the exact screenshot of the error messages you are receiving?