Rename Excel column heading to MATLAB

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

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
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!