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

My excel file has some sheets, but i only want to import one sheet without first row and first column.

[dpb]

Use the 'Sheet' and 'Range' optional arguments to readtable or readmatrix

See the doc for examples.

Answer 1

[Xavier]

opts.Sheet = 'yourSheetName';
T = readtable('youWorkbook.xlsx',opts);
T(1, :) = [];
T(:, 1) = []

Here is the documentation

Answer 2

[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