How to import and read Excel input into an executable
显示 更早的评论
Hello everyone
I need help with reading an excel file as an input into my code which i plan to convert to an executable.
I have to read the data from the excel in such a way that the data from the row 1 and column 1 is assigned to a particular variable in the code, there are 88 such variables. I must access the excel interactively from a file location , then read it and assign the value to these variables.
Can anyone help me with the same, i have limited knowledge in matlab and any lead is Highly appreciated.
Thank you
2 个评论
Bob Thompson
2018-12-17
What kind of flexibility do you have on how you access your data? Is this some kind of homework problem that you have to do exactly what they ask?
deep
2018-12-18
采纳的回答
Guillaume
2018-12-17
1 个投票
readtable will read an excel file and directly transform each column into variables of a table.
I would not recommend having over 80 different variables in any function/script. It would be a complete maintenance nightmare and a clear indication that the design has not been thought out properly. A table would be a lot easier to manipulate.
6 个评论
deep
2018-12-18
Guillaume
2018-12-18
For a start, are all these variables independent? What do they represent? What are you using them for?
Things to consider:
- If the variables are iteration of the same thing, group them in an array. Never have sequentially named variables. Instead of myvar1, myvar2, myvar3, ... have myvar(1), myvar(2), ...
- If the variables are somehow related, group them into a structure. e.g. instead of
ambientpressure = xxx;
ambienttemperature = xxx;
ambienthumidity = xxx;
have
environment.pressure = xxx;
environment.temperature = xxx;
environment.humidity = xxx
You then have only one variable, the structure, to pass to functions instead of 3.
deep
2018-12-19
deep
2018-12-19
Guillaume
2018-12-19
Could you please elaborate on your first point, that will help me in improving my code.
I think it would be better if you showed an example of your code, then we can see if there's a better way of doing it.
deep
2018-12-21
更多回答（1 个）
Luna
2018-12-17
Hi,
You can try below to get all excel data.
[fName,pName] = uigetfile({'*.xlsx';'*.xls'},'Please Select an excel file'); % ask you to put excel file and gets file and path names
[num,txt,raw] = xlsread(fullfile(pName,fName)); % reads the excel and gets the numeric as double array, text as cell array and raw data as cell array
var1 = raw{1,1};
var2 = raw{1,2}; % etc...
% OR if all your data is numeric
var1 = num(1,1);
var2 = num(1,2); % etc ...
% you can also use for loops
OR you can also use Activex but it is a bit complicated see link below:
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Translated by 
