Maybe i can do a boolean variable then find the length of it and i can add it to the first cell of my excel file. So if the length is 0 then i will start to the first cell. But how do I add to the cell number the length of the boolean variable and still be a cell identification.
Include data in excell
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi
I have 3 cell data from matlab that have to be include in excel.
Now the problem is that i want to include the 3 cell data at the first cell of the row that is not already written. This meaning if in excell there is
A1(cell) = 1
A2(cell) = 2
I want to write a script that understands that A1 and A2 cell are already with data and should add the new 3 cell data after the A2 cell (in excel).
I hope you understand what i am talking about. I was thinking of reading first the whole row in a Boolean way and see what are 0 and 1 but then I have a problem of how to tell matlab where he should start to put the data in?
Risposta accettata
Titus Edelhofer
il 18 Nov 2011
Hi Alexandros,
what about the following:
% read the file
[~,~,data] = xlsread('yourfile.xls');
% add at the end your data
data{end+1,1} = 42.0;
% and write the result back to your file:
xlswrite('yourfile.xls', data);
If you need to add more then just one number use [] or indices or something similar ...
Titus
0 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!