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

[Walter Roberson]

Which release are you using? How are you doing the importing?

[Ive J]

what happens if you try ?

T = readtable('YourFile.xlsx', 'ReadVariableNames', true);

[Hui Puong]

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

Answer 1

[Cris LaPierre]

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.

[Cris LaPierre]

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)

data = 3x4 table
    Curent    Voltage    Max output Vol    Max output Cur
    ______    _______    ______________    ______________

     1.2       12.6           12.6              1.3      
     1.3       12.5           12.6              1.3      
     1.2       12.4           12.6              1.3      

% View the table description and unit properties
data.Properties.VariableDescriptions

ans = 1x4 cell array
    {'Raw data'}    {'Raw data'}    {'Raw data'}    {'Ras data'}

data.Properties.VariableUnits

ans = 1x4 cell array
    {'A'}    {'V'}    {'V'}    {'A'}

If you are unfamiliar with how to access data in a MATLAB table, see this page.