How to import excel file only one sheet and skip first column?
64 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
My excel file has some sheets, but i only want to import one sheet without first row and first column.
1 commentaire
dpb
le 8 Sep 2020
Use the 'Sheet' and 'Range' optional arguments to readtable or readmatrix
See the doc for examples.
Réponses (2)
Xavier
le 8 Sep 2020
opts.Sheet = 'yourSheetName';
T = readtable('youWorkbook.xlsx',opts);
T(1, :) = [];
T(:, 1) = []
0 commentaires
Abdolkarim Mohammadi
le 8 Sep 2020
You should use readmatrix(). For example:
M = readmatrix (filename, 'Sheet', 'MySheet', 'Range','B2:Z10');
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!