add constant value to row

2 次查看（过去 30 天）
Gemma
Gemma 2023-1-22
评论： Rik 2023-1-30
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 个评论
显示 1更早的评论
Gemma
Gemma 2023-1-22
Yes .xslx file thanks
Rik
Rik 2023-1-30
@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?

请先登录，再进行评论。

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

回答（2 个）

Matt J
Matt J 2023-1-22
编辑：Matt J 2023-1-22
A=readmatrix('yourFile.xlsx');
A(:,end+1)=600;
VBBV
VBBV 2023-1-22
编辑：VBBV 2023-1-22
A=readmatrix('DATA.xlsx'); % assuming DATA your filename
A(:,end+1)=600;
writematrix(A,'DATA.xlsx','Delimiter','tab') % write data back to same file

类别

在 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