add constant value to row

2023 1 22
2 个回答
更新时间：2023 1 30
26 次查看（30 天）

0 个投票

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更早的评论 隐藏 1更早的评论

Matt J
Matt J 2023-1-22
What's the format of the file? CSV? Binary? Excel spreadsheet?
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

0 个投票

A=readmatrix('yourFile.xlsx');
A(:,end+1)=600;
VBBV
VBBV 2023-1-22
编辑：VBBV 2023-1-22

0 个投票

A=readmatrix('DATA.xlsx'); % assuming DATA your filename
A(:,end+1)=600;
writematrix(A,'DATA.xlsx','Delimiter','tab') % write data back to same file

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

提问:

Gemma
Gemma
2023-1-22

评论：

Rik
Rik
2023-1-30

Community Treasure Hunt

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

Start Hunting!

Translated by