reading a special sheet of an EXCEL file with knowing the row numbers

1 view (last 30 days)
Hello, does anyone know how matlab can read a special sheet of an excel file without knowing row numbers of that sheet? for example one excel file have 150row and the other sheet has 500 rows.

Answers (1)

Image Analyst
Image Analyst on 2 Apr 2014
Simply use xlsread() or readtable(). No big deal - try it.
  2 Comments
Yogesh Babu
Yogesh Babu on 2 Apr 2014
hello, I am interested in importing excel with unknown Rows and columns.for example in one excel i will have data for 100 columns and in some other excel file i have 50 columns how to write condition for unknown ranges.
Image Analyst
Image Analyst on 2 Apr 2014
See my answer. They don't care how many rows or columns you have. Why do you think they do?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!