Exporting workspace variables in excel sheet

Hi,
I have 200 variables in my matlab workspace. how can I export this data into the excel sheet as it is in matlab ?
Variable names should be the headers in the excel sheet.
Thanks in advance !

回答 (1 件)

Ameer Hamza
Ameer Hamza 2020 年 10 月 16 日

1 投票

As Stephen mentioned, creating variable names dynamically is not a good coding practice. A better approach will be to create a table(), and column names can be the same as variable names. Then you can simply use writetable() and it will print variable name as the header row of the Excel sheet.

1 件のコメント

Stephen23
Stephen23 2020 年 10 月 16 日
"...creating variable names dynamically is not a good coding practice."
Also accessing them dynamically, as in this question.

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

カテゴリ

ヘルプ センター および File ExchangeData Import from MATLAB についてさらに検索

質問済み:

2020 年 10 月 16 日

コメント済み:

2020 年 10 月 16 日

Community Treasure Hunt

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

Start Hunting!

Translated by