How to download workspace to a .xls file?

1 次查看（过去 30 天）
Missael Hernandez
Missael Hernandez 2021-9-18
评论： Image Analyst 2021-9-19
I have a hundreds of variables that are defined as strings. For example,
a = "hello world"
b = "Today is sunny"
c = "It is Friday"
These variables are obviously stored in the workspace. How can I download the Workspace to a .xls file such that the strings can be modified by someone who may not have MATLAB in Excel? But also update the string on the Workspace once I upload the updated .xls file. Like for example, someone updates
b = "Today is rainy"
in Excel, and now I would also like to update in the MATLAB workspace. Thank you!

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

回答（1 个）

Image Analyst
Image Analyst 2021-9-18
Try readcell() and writecell(). If someone changes it in Excel, it won't automatically update the workspace in MATLAB. You'll have to call readcell() to read in the changed workbook file.
  2 个评论
Missael Hernandez
Missael Hernandez 2021-9-18
Not automatically. I meant once the .xls file is updated and put on the Current Folder.

请先登录，再进行评论。

类别

在 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