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

14 views (last 30 days)
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

Answers (1)

Kavya Vuriti
Kavya Vuriti on 27 Mar 2020
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.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!