MATLAB Answers

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

16 ビュー (過去 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

  0 件のコメント

サインインしてコメントする。

回答 (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.

  0 件のコメント

サインインしてコメントする。

製品

Community Treasure Hunt

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

Start Hunting!

Translated by