Readtable from i-th row to last row

Question

Clemens Gersch 2019-9-2

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478576-readtable-from-i-th-row-to-last-row

编辑： Jeremy Hughes 2022-7-7

Hi,

I am looking for a solution to read an Excel table via readtable from a specific row on down to the last row. I know in which row to start, but I don't know in before which row exactly is the last row.

The only idea I had by now was doing something like

data = readtable(workbookFile, 'sheet', sheetName, 'ReadVariableNames', true, 'FileType', 'spreadsheet', 'UseExcel', false, 'Range', '7:50000');

where 7 ist the row to start the import and 50000 is a valua that high, it would never be reached. The next step would be to delete all the empty rows, that were created (I'm still figuring out how to do it but thats not a part of my question).

That doesn't seem to be very efficient to me. Does anybody have a better solution?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jeremy Hughes 2019-9-3

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478576-readtable-from-i-th-row-to-last-row#answer_390208

编辑：Jeremy Hughes 2022-7-7

Try this

opts = detectImportOptions(filename,'NumHeaderLines',6)

T = readtable(filename,opts)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Clemens Gersch 2019-9-4

That's it. Thank you very very much.

请先登录，再进行评论。

Answer 2

KALYAN ACHARJYA 2019-9-2

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/478576-readtable-from-i-th-row-to-last-row#answer_390082

编辑：KALYAN ACHARJYA 2019-9-2

在 MATLAB Online 中打开

Readtable from i-th row to last row?

load table, then

or

data=readtable(filename);
i=??? % define
data_read=data(i:end,:)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Clemens Gersch 2019-9-2

I tried that first but that way readtable is not able to detect the table structure of the file to import.

I have an excel-file with 6 rows to drop and then there is a timetable with headlines in row 7, dates in columns 1 (starting in row 8) and the actual data from (8,2) on. I want to import the timetable.

If I just load the data without specifieing the first rows to be dropped, all the cells are strings and I need to convert the cells in the table again, which is not so nice.

请先登录，再进行评论。