How to import excel file only one sheet and skip first column?
52 views (last 30 days)
Show older comments
My excel file has some sheets, but i only want to import one sheet without first row and first column.
1 Comment
dpb
on 8 Sep 2020
Use the 'Sheet' and 'Range' optional arguments to readtable or readmatrix
See the doc for examples.
Answers (2)
Xavier
on 8 Sep 2020
opts.Sheet = 'yourSheetName';
T = readtable('youWorkbook.xlsx',opts);
T(1, :) = [];
T(:, 1) = []
0 Comments
Abdolkarim Mohammadi
on 8 Sep 2020
You should use readmatrix(). For example:
M = readmatrix (filename, 'Sheet', 'MySheet', 'Range','B2:Z10');
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!