How to read from a variable excel cell?

Question

Jonathan Babitsch 2020-7-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/569935-how-to-read-from-a-variable-excel-cell

评论： Jonathan Babitsch 2020-7-24

采纳的回答： Walter Roberson

Hey everybody,

I have a question I don´t find a solution for...

How can i read from a variable excel cell?

I have a variable excel cell I need to read from.

Like for example it is in column A in excel, but now line 10 and in another case 20... And the exact line is calculated before and I want to read from the variable line?

Is that possible?

Thank you guys in advance!

Johnny

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-7-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/569935-how-to-read-from-a-variable-excel-cell#answer_470341

在 MATLAB Online 中打开

N = 55;
cellrange = sprintf('A%d:C%d', N, N);
Kmittelpunkt = xlsread('S:\AM-Design\WORK_Folder_Abschlussarbeiten_Kohler_Gerstadt_Babitsch\eigener_Aufbau\Spline.xlsx', 1, cellrange);