MATLAB Answers

Rename Excel column heading to MATLAB

14 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)

Community Treasure Hunt

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

Start Hunting!