Reading Certain Column from Excel
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello Everyone , I am trying to read certain column , from Multisheet Excel, which I am using as input for my Calculation
clc
clear
clearvars
opts = detectImportOptions('Fatigue_life_input.xlsx','Sheet','Input Data','NumHeaderLines',1);
opts.VariableNames = 'Values';
datos = readtable('Fatigue_life_input.xlsx',opts)
Here I am trying to read , Sheet name : Input Data from Filename Fatigue_life_input and I want to read Numeric values which is column 2 . But instead of that it is read column 1.

This is my Input file is excel , I am trying to read only values section

And this is what i am getting in MATLAB.
0 commentaires
Réponses (1)
Image Analyst
le 17 Oct 2022
You forgot to attach the workbook. Please do so. What I usually do is
datos = readtable('Fatigue_life_input.xlsx', 'Sheet', 'Input Data', 'Range', 'B2:B19')
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!