MATLAB Answers

Can I create and modify variables in an Excel sheet?

18 views (last 30 days)
Missael Hernandez
Missael Hernandez on 16 Sep 2021
Commented: Missael Hernandez on 16 Sep 2021 at 22:10
Suppose that someone does not have access to MATLAB, but does to Excel. Could they edit a variable in an Excel sheet, send that sheet to me, and once I upload to it to the Current Folder in MATLAB, have those modifications show up in the workspace?
  1 Comment
Geoff Hayes
Geoff Hayes on 16 Sep 2021
Missael - if someone sends you an updated Excel spreadsheet then those modifications will show up in the MATLAB workspace only once you read (via whichever MATLAB code that you have written) that updated file.

Sign in to comment.

Answers (1)

Image Analyst
Image Analyst on 16 Sep 2021
Yes, they can give you data in whatever form you like - text file, csv file, xlsx file, etc. Then you can read in the file and use that variable. When you read them in, they will show up in the workspace.
Missael Hernandez
Missael Hernandez on 16 Sep 2021 at 22:10
The highlighted portion is where the string goes. All you do is click the 3 vertical dots to make it a variable and it'll show up in the Workspace.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by