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

11 Ansichten (letzte 30 Tage)
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

Antworten (1)

Kavya Vuriti
Kavya Vuriti am 27 Mär. 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.

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by