Search code examples
pythonexcelxlwings

Excel hyperlink not working "cannot open the specified file"

I have a python app and I'm using xlwings to write to an Excel file. I am trying to create a link to another file. For now, I am trying to link to an Excel file. I am using the code:

ws.range(15, 8).value = '=HYPERLINK("C:\\file.xlsx")'

This creates a link but when I click the link I get the error "cannot open the specified file". The cell value is =HYPERLINK("C:\file.xlsx"). If I create a link to the same file using the "Insert Link" button in Excel it works and both cells show the same file path. Also I will need to create a link to a non-excel file that needs to be opened with a different program. How can I do this?

Solution

  • You should use the add_hyperlink method.

    Example:

    ws.range(15, 8).add_hyperlink("C:\\file.xlsx")