Please refer to this document for your help.
Adding Hyperlinks to Link Data
Thank is the same link that I have from my first post. I’ve already went through the documentation and tutorial. I’m thinking it might be a bug or there is something that I am not understanding. The example from the documentation has a spreadsheet name but the name does not a space in the example. With what I( am trying to work with it does have a space in the name. Example will you get the same expected result from the following two calls:
For reference to sheet whose name has special
characters, please use ‘’ to quote the sheet name, such as:<o:p></o:p>
worksheet.getHyperlinks().add("B1", 1, 1, "’Sheet 9’!A1");
It is the same way that works in MS Excel too.