How can I load data from Excel file to Matlab in script and use the data loaded to calculate?

Question

Newbie 2023-2-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1920555-how-can-i-load-data-from-excel-file-to-matlab-in-script-and-use-the-data-loaded-to-calculate

评论： Newbie 2023-2-28

Hi guys, I am a newbie in Matlab and I am using Matlab for my thesis. I have an excel file contain data and I want to load these data into Matlab and therefore I can write programme to calculate using these data in Matlab. How can I do that? Can you show me the full code because I am so new to this. Thank you very much!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Hill 2023-2-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1920555-how-can-i-load-data-from-excel-file-to-matlab-in-script-and-use-the-data-loaded-to-calculate#answer_1181900

Use readmatrix or readtable. If you attach your spreadsheet we could help more.

2 个评论
显示无隐藏无

Newbie 2023-2-28

Relaxation data.xlsx

Hi this is my Excel file

Newbie 2023-2-28

My code

clc

syms t s Gs Gt Ks Es Et

E0 = [10490.3622];

v = 0.3;

Et = simplify(laplace(Et, t, s));

Ks = E0/(3*s*(1-2*v));

Gs = (9*Ks-Es)/(Es*Ks);

Gt = ilaplace(Gs,t);

writematrix([value_t(:),Gt(:)],'C:\Relaxation modulus\data.xlsx');

请先登录，再进行评论。

Answer 2

David Hill 2023-2-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1920555-how-can-i-load-data-from-excel-file-to-matlab-in-script-and-use-the-data-loaded-to-calculate#answer_1181950

在 MATLAB Online 中打开

Relaxation data.xlsx

MSU1=readmatrix('Relaxation data.xlsx','Range','A4:E82')%load the others following the same method
MSU1 = 79×5
0e+04 *

         0         0         0       NaN         0
0000         0    0.0001       NaN       NaN
0003    0.0000    0.0005    0.4870    0.1873
0005    0.0000    0.0008    0.8009    0.3080
0007    0.0000    0.0013    1.1517    0.4430
0009    0.0000    0.0016    0.6929    0.2665
0011    0.0000    0.0019    0.8668    0.3334
0013    0.0000    0.0023    1.0303    0.3963
0014    0.0000    0.0026    0.5757    0.2214
0016    0.0000    0.0029    0.8582    0.3301