Readtable importing variables from wrong sheet
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!