Include data in excell

1 次查看（过去 30 天）
Alexandros
Alexandros 2011-11-18
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?
  1 个评论
Alexandros
Alexandros 2011-11-18
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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Titus Edelhofer
Titus Edelhofer 2011-11-18
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

更多回答（1 个）

Alexandros
Alexandros 2011-11-18
i found the answer
I did a map of all the possible cells that can be found in excell thus i can directly related with it in my matlab code and put things where i need them

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by