Trying to run the python code below and log message shows access denied
def ExcelExample():
excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx")
Notes
1.excel does have password and manually, it can open
Thank you
Champion Level 3Is the spreadsheet already opened in Excel? I suggest you check your Task Manager to ensure no other Excel processes are opened.
Thank you for the update!
did check and no other Excel file is opened
Champion Level 1Hello,
I am not sure I understand your message. The error says "removing file" while your statement is open file. If you are attempting to delete an open file, first you need to close it.
I don't believe TestComplete can open a password protected file, I get a different error. Probably you need third party libraries to decrypt.
Hi,
Thank you for the update
I have recorded steps. Please see
Please find attached
Champion Level 3There's no recorded steps or anything attached!
please check now
Champion Level 3Still, nothing is attached, to either the original post or your responses.
Something was wrong
Please check now
Champion Level 3You are opening a different file here, which is not C:\\temp\\DataStorageExcel.xlsx?
The example that I've tried, works fine
I suggest you use double back-slash as opposed to raw string in path name.
When you double click the error message, what line does it take you to? Because the error message is relating to removing a file, and not opening a file!
When file is already open or read protected, Save will errorCan you provide that exact code that is actually failing? You can use "Insert/Edit Code Sample" icon
Sorry for the confusion. According to previous screenshot, the location path is correct
Champion Level 3Create a new project, with your code, to eliminate any other issues.
Provide that exact code that is actually failing, you can use "Insert/Edit Code Sample" icon
