How to import excel file only one sheet and skip first column?

66 次查看（过去 30 天）
Nadia Swastiti
Nadia Swastiti 2020-9-8
评论： dpb 2020-9-8
My excel file has some sheets, but i only want to import one sheet without first row and first column.

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

回答（2 个）

Xavier
Xavier 2020-9-8
opts.Sheet = 'yourSheetName';
T = readtable('youWorkbook.xlsx',opts);
T(1, :) = [];
T(:, 1) = []
Here is the documentation
Abdolkarim Mohammadi
You should use readmatrix(). For example:
M = readmatrix (filename, 'Sheet', 'MySheet', 'Range','B2:Z10');
Readmatrix documentation: https://www.mathworks.com/help/matlab/ref/readmatrix.html

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by