Rename Excel column heading to MATLAB
16 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hello everybody question is in the heading
0 Commenti
Risposta accettata
Bhaskar R
il 12 Feb 2020
Modificato: Bhaskar R
il 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 Commenti
Bhaskar R
il 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!