using fprintf to print selected rows from an excel file?

Question

0 个投票

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 个评论
显示无隐藏无

Walter Roberson 2016-9-6

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 2016-9-6

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 2016-9-6

1 个投票

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.