problem with reading data from excel

1 次查看（过去 30 天）

Prakhar Modi 2019-8-20

评论： Prakhar Modi 2019-8-20

Hello everyone,

let say I have an excel file say.

x1/x2 1 2 3 4 5

1 4 12 45 54 48

2 6 15 20 59 62

3 7 17 25 60 78

4 8 19 26 62 80

5 9 20 27 64 86

so now i am getting some values of x1 and x2 and i want that the code should read a particular value for x1 and x2. For example

x1=2, x2=4, ans=59

x1=3, x2= 5, ans=78

so is this possible that code itself read data for .mat file or excel file

Alex Mcaulley 2019-8-20

Do you mean this?

data = xlsread('yourExcel.xlsx');
data = data(2:end,2:end)
data(2,4) %For example: x1 = 2; x2 = 4

Prakhar Modi 2019-8-20

Thanks man

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

R2018a

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

Translated by