Hello, I am working on a project in which I am adding Hyperlinks to Cells in a xlsx file. I attempted to use the ss.usermodel hyperlink functionality, however I was unable to achieve the desired results. I was able to create a hyperlink to a file in the current directory, or even in any directory (as long as path does not contain special characters like spaces). However I would like to create a hyperlink to a specific directory or network location (ie "\\My network\Group A\User C\Folder F\" etc...) just as you can manually in Excel. I was unable to get the hyperlink setAddress function to work under these circumstances. I have been able to work around this by setting the cells formula using the Excel hyperlink formula. This work around provides the functionality, however its somewhat messy to have the long hyperlink formula displayed in the function bar whenever the cell is selected (this does not happen when hyperlinks are added correctly). Is there anyway to achieve this desired behavior for hyperlinks in Excel (xlsx) fils?
David
