I need to hand in one script as my final project, how do I do this when I have a separate workspace that was made in excel?

Question

Andy Keane 2016-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265934-i-need-to-hand-in-one-script-as-my-final-project-how-do-i-do-this-when-i-have-a-separate-workspace

评论： Image Analyst 2016-2-1

Hi guys, I have to hand in my complete Matlab script but the problem is that the workspace was made by a project partner in excel (I think). So I have to load the array separately after loading my matlab code. How do I "Import" all of those variables from the array in the workspace into the code to make it one script file? We have to hand in one matlab script, not "a script and a workspace", if you know what I mean? Many thanks in advance.

6 个评论
显示 4更早的评论隐藏 4更早的评论

Stephen23 2016-1-31

Of course normally it is considered good practice to keep code and data quite separate, so there are no easy ways to convert data (external, or in the workspace) into some text that can be put in a script. However, if you really can only submit one file then there is not much choice...

You might like to take a look at these FEX submssions, which claim to be able to turn variables into strings (that could be inclued in your script):

http://www.mathworks.com/matlabcentral/fileexchange/19953-uneval-var-name--value--return-cell-array-

http://www.mathworks.com/matlabcentral/fileexchange/54968-any2ascii

I do not use Microsoft products, so I cannot help you with accessing the database. I can only add that you should not use individually numbered variables (as are indicated in your screenshot), here is why:

http://www.mathworks.com/matlabcentral/answers/196952-how-to-create-new-variables-in-batches-with-strcat

Andy Keane 2016-1-31

Such is the bummer of project work. You have to deal with other people! I'll give that a look over, you would think there would be an easy way to just import the data in. In fact, I think he might have used matlab to create it. it has the A variable for the array in it.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2016-2-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/265934-i-need-to-hand-in-one-script-as-my-final-project-how-do-i-do-this-when-i-have-a-separate-workspace#answer_208032

在 MATLAB Online 中打开

You have a .mat file. Most likely it's a MATLAB file, not a Microsoft Access Table file. See this support document: http://www.mathworks.com/matlabcentral/answers/103000-why-have-all-my-mat-files-become-associated-with-microsoft-access

Your script can read in the xlsx or mat file with a function call like xlsread(), readtable(), or load(). If you can't have a separate file, then you can read it in and type the name of the variable in the command window. Then copy all the stuff it spews out and paste it into a script editor window. Add brackets to make it an assignment. For example to get "x",

>> x
x =
         0.939001561999887         0.550156342898422         0.587044704531417         0.301246330279491
         0.875942811492984         0.622475086001227         0.207742292733028         0.470923348517591

Then just add opening and closing brackets to make it into an array:

x =[...
         0.939001561999887         0.550156342898422         0.587044704531417         0.301246330279491
         0.875942811492984         0.622475086001227         0.207742292733028         0.470923348517591]; 
% Note how I added ]; at the end to finish the array.

Now that can be in the script with all the rest of your commands.

2 个评论
显示无隐藏无

Andy Keane 2016-2-1

This looks perfect! Thanks! I will give this a go in uni and let you know how I get on, I figured it may involve the "load" function. Cheers!

Image Analyst 2016-2-1

OK, let me know how it goes. The command window may not be able to hold all the printout if your array is huge. I'm not sure how much it can hold before you lose them off the top of the command window.

请先登录，再进行评论。