using fprintf to print selected rows from an excel file?

4 views (last 30 days)
i'm trying to use fprintf to print all three columns of an excel file, but only the first five rows. how do i go about this? thank you.
  2 Comments
Walter Roberson
Walter Roberson on 6 Sep 2016
Insufficient information about the data types of the columns. Does "first five rows" include one or more header lines? Are any of the columns dates?
Anjum Syed
Anjum Syed on 6 Sep 2016
sorry, i should've clarified - yes, there are header lines, but i meant the first five lines of data. my xlsread code reads like this:
q = xlsread('G:\file.xlsx','sheet','A2:C7') with A2:37 being all 6 rows and 3 columns of data.

Sign in to comment.

Answers (1)

Keith Hooks
Keith Hooks on 6 Sep 2016
You could do something like this:
[len, width] = size(q);
for row = 1:len
fprintf('%d %s %s\n', q{row,1}, q{row,2}, q{row,3})
end
I made some assumptions about your data types. You might want to customize the %d, %s placeholders to your needs.

Products

Community Treasure Hunt

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

Start Hunting!