extracting datas from excel
1 view (last 30 days)
Show older comments
cemsi888
on 23 Jan 2015
Answered: Luuk van Oosten
on 23 Jan 2015
Hi again !! today i have one question too.But this time it is about Excel... We are making experiments and we are taking experiments outcomes in Excel .But the Problem is: the amount of outcomes or results Change from experiments to experiments. Namely;
Pressure(1.Experiment): 1 2 3 4 5....
Pressure (2.Experiment):1 2 3 4 5 6 7 8 9 .. As you see the results vary from Experiment to Experiment. Is it possible that to coding this Problem. Is there any code to solve this Problem.or should i Change column ranges in m-file-
as you know: xlsread (filename,xLrange) I Need your help!!!!
0 Comments
Accepted Answer
Luuk van Oosten
on 23 Jan 2015
You could set the range to import to a very high number; If your amount of columns is fixed (let us say from A to E), but your amount of rows is varying (but you know it is never more than 1000) you could use somthing similar:
xlsread(filename,A1:E1000)
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!