using fprintf to print selected rows from an excel file?

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.

[Walter Roberson]

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]

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.

Answer 1

[Keith Hooks]

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.