Rename Excel column heading to MATLAB

Hello everybody question is in the heading

Answer 1

[Bhaskar R]

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

[Megan]

What do I have to wirte instead of 'Var1'? The variable names of my Excel (KB61_10) or the renamed version (like_01)?

[Megan]

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]

"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