Forum Discussion

jaydesai's avatar
jaydesai
Occasional Contributor
2 years ago

Test complete tool does have rights to open excel file

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 man...
  • rraghvani's avatar
    rraghvani
    Icon for Champion Level 3 rankChampion Level 3
    2 years ago

    You 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 error

    Can you provide that exact code that is actually failing? You can use "Insert/Edit Code Sample" icon