清空筛选条件
清空筛选条件

Readtable importing variables from wrong sheet

1 次查看（过去 30 天）
Andrea Vezzoli
Andrea Vezzoli 2023-11-29
编辑： Stephen23 2023-11-29
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

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2023-11-29
编辑：Stephen23 2023-11-29
ImpOpts = detectImportOptions(FullPath, "Sheet",2);
ImpOpts.PreserveVariableNames = true;
MeasData = readtable(FullPath, ImpOpts);
Or simply:
MeasData = readtable(FullPath, 'Sheet',2, 'VariableNamingRule','preserve')

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by