Azzera filtri
Azzera filtri

Adding Data Already Existing Excel Sheets

13 visualizzazioni (ultimi 30 giorni)
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 Commenti
darova
darova il 5 Mar 2020
Do you want to append data? Or you already know where to write (row and column)?
Onur ALPAY
Onur ALPAY il 5 Mar 2020
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).

Accedi per commentare.

Risposta accettata

darova
darova il 5 Mar 2020
Try writematrix
writematrix(M,'Sample.xlsx','Sheet',1,'Range','D3:D6')
  4 Commenti
Moh. Saadat
Moh. Saadat il 27 Apr 2020
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
darova il 27 Apr 2020
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

Accedi per commentare.

Più risposte (1)

Champuram Madhu
Champuram Madhu il 5 Mar 2020
You can refer here

Community Treasure Hunt

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

Start Hunting!

Translated by