add constant value to row

2 vues (au cours des 30 derniers jours)
Gemma
Gemma le 22 Jan 2023
Commenté : Rik le 30 Jan 2023
Hi,
I need to add a constant value (600) to all rows of my file = DATA. But, I want to add that DATA to an array.
thanks!
  3 commentaires
Afficher 1 commentaire plus ancien
Gemma
Gemma le 22 Jan 2023
Yes .xslx file thanks
Rik
Rik le 30 Jan 2023
@Gemma What makes your question a duplicate? Does either answer work for you? Why didn't you accept either of them? And if they didn't work, why didn't you comment with an explanation of what was different from what you want?

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponses (2)

Matt J
Matt J le 22 Jan 2023
Modifié(e) : Matt J le 22 Jan 2023
A=readmatrix('yourFile.xlsx');
A(:,end+1)=600;
VBBV
VBBV le 22 Jan 2023
Modifié(e) : VBBV le 22 Jan 2023
A=readmatrix('DATA.xlsx'); % assuming DATA your filename
A(:,end+1)=600;
writematrix(A,'DATA.xlsx','Delimiter','tab') % write data back to same file

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by