Variables name changed when import Excel datas into Matlab
显示 更早的评论
Hello,
I tried to imported a large amount of data from Excel to Matlab but for some reason the variable name got changed to nAN, Anyone know how to keep the original variable name?
For example: My variables name in Excel are Current, Voltage, max output and then it all changed to nAN after got imported to Matlab
3 个评论
Walter Roberson
2021-2-6
Which release are you using? How are you doing the importing?
Ive J
2021-2-6
what happens if you try ?
T = readtable('YourFile.xlsx', 'ReadVariableNames', true);
Hui Puong
2021-2-6
the realease version I'm using is R2020b but I'm using your piece of command T = readtable('YourFile.xlsx', 'ReadVariableNames', true); And it still not working. Do you have any suggestions I can try? Thank you
This pic is after imported the data in Matlab
This pic is from Excel
回答（1 个）
Cris LaPierre
2021-2-6
I'd try something like this.
readtable("sampleTable.xlsx","VariableNamingRule","preserve","NumHeaderLines",1)
In R2020b, MATLAB is able to detect that row 3 is not part of the data, and will skip it.
1 个评论
If you want to capture the descriptions (row 1) and the units (row 3) along with the variable names (row 2), you can do the following.
opts=detectImportOptions("sampleTable.xlsx");
opts.VariableDescriptionsRange=1;
opts.VariableNamesRange=2;
opts.VariableUnitsRange=3;
opts.PreserveVariableNames=true;
data=readtable("sampleTable.xlsx",opts)
% View the table description and unit properties
data.Properties.VariableDescriptions
data.Properties.VariableUnits
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2021-2-6
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
