Rename Excel column heading to MATLAB

16 次查看（过去 30 天）
Megan
Megan 2020-2-12
编辑： Megan 2020-2-19
Hello everybody question is in the heading

请先登录，再回答此问题。

采纳的回答

Bhaskar R
Bhaskar R 2020-2-12
编辑：Bhaskar R 2020-2-12
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 个评论
显示 1更早的评论
Megan
Megan 2020-2-12
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 2020-2-12
"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
https://in.mathworks.com/help/matlab/ref/readtable.html

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by