Readtable importing variables from wrong sheet
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Andrea Vezzoli
el 29 de Nov. de 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 comentarios
Respuesta aceptada
Stephen23
el 29 de Nov. de 2023
Editada: Stephen23
el 29 de Nov. de 2023
ImpOpts = detectImportOptions(FullPath, "Sheet",2);
ImpOpts.PreserveVariableNames = true;
MeasData = readtable(FullPath, ImpOpts);
Or simply:
MeasData = readtable(FullPath, 'Sheet',2, 'VariableNamingRule','preserve')
0 comentarios
Más respuestas (0)
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!