Iam new to matlab... Beginner..

4 views (last 30 days)
Rizwana
Rizwana on 25 Oct 2013
Commented: Matt Kindig on 25 Oct 2013
I have imported an excel file which reads 1367*17 rows & columns.. In my program i should read starting or in between 10 rows & 10 columns & plot contours... How to use for looping for this cenario & the code should be user defined... for eg... when user enters 10 then 10 rows & coulumns should be read out... Please help me... If not possible to write codes,suggest me links where i can read & try to code..

Accepted Answer

David Sanchez
David Sanchez on 25 Oct 2013
rows = input('Enter matrix size: '); % user input
end_cell = strcat(char(65+rows),num2str(rows));
range = strcat('A1:',end_cell); % if rows = 10, range = 'A1:K10'. If rows = 5, range = 'A1:F5'
M = xlsread('my_excel_file.xls',range); % the matrix you want
  2 Comments
Rizwana
Rizwana on 25 Oct 2013
Thank you so much. Can you help me out suggesting me a matlab text book.. I want to to get fluent with excel data manipulation using matlab. I will really greatfull.
Matt Kindig
Matt Kindig on 25 Oct 2013
While there are a number of good Matlab books out there, you might just want to start with the "Getting Started" section in the Help documentation. Just open Help, and click the "Getting Started" link in that page, and go through those tutorial videos first.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB 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!