Readtable importing variables from wrong sheet
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Andrea Vezzoli
il 29 Nov 2023
Modificato: Stephen23
il 29 Nov 2023
Hello everyone, I am facing a weird issue with readtable that I have never seen before. The code I am using is the following:
[FileName, FilePath] = uigetfile("*.xlsx;*.xls", "Select the right results file");
FullPath = fullfile(FilePath, FileName);
ImpOpts = detectImportOptions(FullPath);
ImpOpts.Sheet = 2;
ImpOpts.PreserveVariableNames = true;
MeasData = readtable(FullPath, ImpOpts);
The output contains only a part of the columns that I would need from Sheet 2 because it recognises as varibles the header from Sheet 1. I have never faced this issue before and feel like the solution must be stupid but I can't seem to find it.
I really need to use an integer to specify the sheet, but also by specifying the sheet name, it does not work. Has anyone had this problem before?
Thanks
Andrea
0 Commenti
Risposta accettata
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Logical in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!