How can I create a hyperlink to a folder through matlab in an xls column?

Hi,

I have a matlab script that goes through a set of data and after calculations, at the end generates a table from results and exports it to an xls sheet. I want to add a column in my xls sheet including the directory of the data. And I want to save the directory in excel as a hyperlink. How can I implement it in my matlab code? I do not want to seperately use hyperlink formoula in excel. I want to do everything in that one matlab code.

Thanks,

NK

Answer 1

[Kavya Vuriti]

Hi,

You can use the following command to create hyperlink to open windows explorer to a particular folder(C drive in this case):

disp('<a href="matlab:dos(''explorer.exe /e, c:\, &'')">hyperlink text</a>')

To add hyperlink to excel, you can refer this.