How to import and read Excel input into an executable

2 次查看（过去 30 天）

显示更早的评论

deep 2018-12-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/436150-how-to-import-and-read-excel-input-into-an-executable

评论： deep 2019-2-1

采纳的回答： Guillaume

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

I have complete flexibility on accesing the data. No restriction.

请先登录，再进行评论。

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

采纳的回答

Guillaume 2018-12-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/436150-how-to-import-and-read-excel-input-into-an-executable#answer_352801

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 个评论
显示 4更早的评论隐藏 4更早的评论

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

Force.m

Sure,

I have attached the file for your perusal.

请先登录，再进行评论。

更多回答（1 个）

Luna 2018-12-17

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/436150-how-to-import-and-read-excel-input-into-an-executable#answer_352796

在 MATLAB Online 中打开

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:

Excel actxserver

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

deep 2019-1-31

Thank you

deep 2019-2-1

I have observed that Xlswrite works,

Could you please tell me the reason for recommending ActiveX?

Thank you

请先登录，再进行评论。

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by