add constant value to row

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!

[Matt J]

What's the format of the file? CSV? Binary? Excel spreadsheet?

[Gemma]

Yes .xslx file thanks

[Rik]

@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?

Answer 1

[Matt J]

A=readmatrix('yourFile.xlsx');

A(:,end+1)=600;

Answer 2

[VBBV]

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