Reading excel files ignoring first X rows

29 次查看（过去 30 天）
David C
David C 2012-4-24
New to matlab here so please excuse me if my questions are too simple
I'm trying to use the xlsread function, but have it omit the first x number of rows.
My spreadsheet contains 2-3 lines of random stuff before the actual header and data.
Can xlsread do that? or should I resort to textscan?
Thanks

请先登录，再回答此问题。

回答（2 个）

Yersinio Jimenez
Yersinio Jimenez 2012-4-24
Is possible to specify data range to be readed in xlsread function third and fourth parameters. Does this solve your issue?
Walter Roberson
Walter Roberson 2012-4-24
Pass a "range" into xlsread().
I do not know of any way to specify "row 4 onwards" when the number of rows is unknown. People have posted methods of doing that, but if you do not fire up an activex object to handle the reading, figuring out the number of rows is fairly inefficient, and you might be best to just read everything and throw away the rows you do not want.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by