Adding Data Already Existing Excel Sheets

Hi,

I created an excel file nade "DATA". There are seven different sheets in it and the firs one is "PAGE1". My code gives numerical data at the end. I want put this data into a spesific row and colomn in the already excisting "DATA" file "PAGE1" sheet. How can I do that?

[darova]

Do you want to append data? Or you already know where to write (row and column)?

[Onur ALPAY]

Already know row and column, like G8:G18. Some other cells was filled with other datas. I have attached an excel file. In this case I want put some data into empty cells (E3:E6).

Answer 1

[darova]

Try writematrix

writematrix(M,'Sample.xlsx','Sheet',1,'Range','D3:D6')

[Onur ALPAY]

Thank you so much. It is solved. I have one more question.

I want to put a string expression into a cell like 'F1'. How can I do that?

[darova]

I don't have writematrix. I used xlswrite and cell

A = {'my string'};                          % put string in cell
xlswrite('Sample.xlsx',A,'Sheet1','F1')

[Moh. Saadat]

Hi, is there any way I can append a row to an existing excel sheet without explicitly specifying the 'Range'?

For instance, I already have:

1 2

5 1

and I need to add another row with [0 3]: instead of using

writematrix(filename, var, 'Range', 'A3:B3');

I want something like

writematrix(filename, var, 'append')

The problem with specifying 'Range' is that the number of columns I will have in my variable is not fixed; that's why specifying the range explicitly becomes more complicated than it should be.

Thanks in advance!

[darova]

There is no append option. You can only read the whole matrix

Try this

A = readmatrix('data.xlsx','sheet',1);  % read the whole matrix
A = [A; 0 3];                           % append data
writematrix('data.xlsx','sheet',1)      % write new matrix

Answer 2

[Champuram Madhu]

You can refer here

[Onur ALPAY]

I have tried it first but i did not work.