i want to store 3 attributes in 3 columns of excel sheet and 10 times

code is>>>> f1='13_1_1'; f2='13_1_2'; a=0;

i want to create excel sheet named sheet1 having 3 columns where in firts attribute value of f1, second attribute value of f2 and in 3rd attribute value of a should get stored and i want to repeat the writing process.

Answer 1

[ANKUR KUMAR]

f1='13_1_1'; 
 f2='13_1_2'; 
 a=0;
 A={f1,f2,a}
 xlswrite('sample.xlsx',A,'sheet1 ','A1')

You can easily put this in a loop. If not, let us know.

[amrin shaikh]

hello Sir with your help I am able to save in excel file but my newer doubt is if I re-execute the code previously written content should be there and other data should come in new line.

if i use append function it does not work.please help me thank you in advance.

[ANKUR KUMAR]

No need to use append. You can do the same giving cell as input. If you wish to change the sheet, you can do easily. Here is an example.

A=rand(6,12)+10 %random data
xlswrite('sample.xlsx',A,'sheet name','A1')

% now you already have file names sample.xlsx in which data is spreaded
% upto A1 to L6. Now suppose you wish to append in first row after L column

xlswrite('sample.xlsx',[2,5,8,9,6,3,5],'sheet name','M1')

%first row of xlsx file have columns upto R and remaing have still up to M
%now, suppose you want to add down of the complete written data

xlswrite('sample.xlsx',magic(5),'sheet name','A8')

[amrin shaikh]

but sir when i execute your previous code it shows like 13_1_1 13_1_2 1 in excel sheet row 1. but when i re-execute code it overwrites.

i dont want content to be appended in columns i want newer value of A in next raw by keeping previous data.

for example 13_1_1 13_1_1 1 f1 f2 1 f3 f4 0

please help me. thank you in advance

[amrin shaikh]

[ANKUR KUMAR]

It will overwrite the data if you re-execute the program with different values, because writing process in excel always starts with cell A1. You have to give cell number as input, then pass the cell number argument at the time of writing in excel.

TIP: Don't write multiple times in excel, as it complicated because everytime you have to provide cell number. Make a cell matrix,completely, in matlab in the manner you wish to write in excel and then use xlswrite command.