Adding Data Already Existing Excel Sheets

Question

Onur ALPAY 2020-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509185-adding-data-already-existing-excel-sheets

评论： darova 2020-4-27

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?

2 个评论
显示无隐藏无

darova 2020-3-5

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

Onur ALPAY 2020-3-5

sample.xlsx

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 2020-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509185-adding-data-already-existing-excel-sheets#answer_418683

在 MATLAB Online 中打开

Try writematrix

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

4 个评论
显示 2更早的评论隐藏 2更早的评论

Moh. Saadat 2020-4-27

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 2020-4-27

在 MATLAB Online 中打开

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