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

15 次查看（过去 30 天）
Nazanin Karimi
Nazanin Karimi 2020-3-4
回答： Kavya Vuriti 2020-3-27
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

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by