Extract a specific range of rows from an excel file using opts = detectImportOptions(filename)

5 次查看（过去 30 天）

显示更早的评论

Sergio 2024-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2083128-extract-a-specific-range-of-rows-from-an-excel-file-using-opts-detectimportoptions-filename

评论： Sergio 2024-2-19

采纳的回答： Dyuman Joshi

在 MATLAB Online 中打开

I try to extract rows 191-222 from an excel file, and I use opts = detectImportOptions(filename)

However, by inspecting the weblink for this on MATLAB, I cannot find how to narrow down to a range, 191-222.

I tried

opts = detectImportOptions('tempDataTrollhFlygpl.xlsx',  'NumHeaderLines', 191-222, 'VariableNamingRule','preserve');
opts = setvartype(opts, 4, 'double');
D=readtable('tempDataTrollhFlygpl.xlsx',  opts)
M = D(:,[3 4])

But that won't work. Any ideas how to limit opts = detectImportOptions to extract only within rows 191-222?

Thanks!

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

请先登录，再进行评论。

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

采纳的回答

Dyuman Joshi 2024-2-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2083128-extract-a-specific-range-of-rows-from-an-excel-file-using-opts-detectimportoptions-filename#answer_1410673

在 MATLAB Online 中打开

Specify the data range to be read using the 'Range' option -

opts = detectImportOptions('tempDataTrollhFlygpl.xlsx', ...
                        'Range', '191:222', 'VariableNamingRule','preserve');
opts = setvartype(opts, 4, 'double');
D=readtable('tempDataTrollhFlygpl.xlsx',  opts);
M = D(:,[3 4])

8 个评论
显示 6更早的评论隐藏 6更早的评论

Dyuman Joshi 2024-2-19

在 MATLAB Online 中打开

No, that is an expected behaviour. As M is a table, so using mean() directly on it calculates the mean of each variable.

If you want to calculate the mean of a particular variable in a table, use curly brackets to access the data in it or use the dot indexing as you did in plotting the data