MATLAB Answers

Rename Excel column heading to MATLAB

11 views (last 30 days)
Megan
Megan on 12 Feb 2020
Edited: Megan on 19 Feb 2020
Hello everybody question is in the heading

  0 Comments

Sign in to comment.

Accepted Answer

Bhaskar R
Bhaskar R on 12 Feb 2020
Edited: Bhaskar R on 12 Feb 2020
data = readtable('<your xlsx file name>'); % read your file as table
data.Properties.VariableNames = {'Var1', 'Var2', ..... so on as your data and required column names}
writetable(data, '<your xlsx file name>') % write back modified data to excel file

  3 Comments

Megan
Megan on 12 Feb 2020
What do I have to wirte instead of 'Var1'? The variable names of my Excel (KB61_10) or the renamed version (like_01)?
Megan
Megan on 12 Feb 2020
Is it possible do input a csv file? Because my xls deleted some of the columns.
I tried this:
data = readtable ("data.csv");
And I get this Error code:
Error using readtable (line 216)
Cannot interpret data in the file 'data.csv'. Found 2 variable names but 1
data columns. You may need to specify a different format, delimiter, or number
of header lines.
Note: readtable detected the following parameters:
'Delimiter', ',', 'HeaderLines', 22, 'ReadVariableNames', true, 'Format', '%q'
Error in analysis (line 3)
data = readtable ("data.csv");
Bhaskar R
Bhaskar R on 12 Feb 2020
"What do I have to wirte instead of 'Var1'? The variable names of my Excel (KB61_10) or the renamed version (like_01)?" -Yes
"Is it possible do input a csv file?" -Yes
You got error because data in csv file is in not proper way, to avoid error/get data give appropriate inputs to the readtable
for more details

Sign in to comment.

More Answers (0)

Sign in to answer this question.