How to read from a variable excel cell?

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

Answer 1

[Walter Roberson]

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);

[Jonathan Babitsch]

Great as always!!

Big thank you for your help, appreciate it!