how to write data to xls sheet?

Question

Arun Badigannavar 2013-1-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59742-how-to-write-data-to-xls-sheet

评论： nehad mohamed 2021-1-17

      value_F = 0.1,0.2,0.3,0.4,0.5,0.6
      filename = 'C:\Documents and Settings\admin\Desktop\test.xlsx';
      value_F
      Data= {'value_F';value_F};
      sheet = 1;
      xlRange = 'B';
      xlswrite(filename,Data,sheet,xlRange)
where value_F is calculated from simulink model and asiigned to workspace,,,am able write oly value_F,,,am unable to write all the values of value_F

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

nehad mohamed 2021-1-17

how to write all value for F every value in cell in sheet

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-1-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59742-how-to-write-data-to-xls-sheet#answer_72287

在 MATLAB Online 中打开

Try using 'B1' for the range and not just 'B' - it should correspond to what ranges look like in Excel. Next, all cells in your cell array go into a cell in Excel, so you can't have a whole array in one cell. I've looked over my Excel writing code and I put all each element in a numerical array into their own cell. So have a for loop where you iterate over all numbers in your numerical array and put them into their own cell, something like this (untested):

[rows columns] = size(value_F);
myCellArray = cell(rows+1, columns);
myCellArray{1,1} = 'value_f'; % First row has only this
% Now assign rows 2 and lower of our cell array.
for col = 1 : columns
  for row = 1
    myCellArray{row+1, column} = myNumericalArray(row, column);
  end
end
xlswrite(filename, myCellArray, sheet, xlRange)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Jing 2013-1-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59742-how-to-write-data-to-xls-sheet#answer_72229

编辑：Jing 2013-1-24

在 MATLAB Online 中打开

If there're both CHAR data and DOUBLE data, I prefer to use XLSWRITE twice to make it work without extra effort. Here I assume value_F is a double matrix.

xlswrite(filename,data(1),1,'A1');
xlswrite(filename,data{2},1,'A2');

3 个评论
显示 1更早的评论隐藏 1更早的评论

Jing 2013-1-24

Just use the code I provided above, it can do that, just write twice...

Arun Badigannavar 2013-1-25

thanks am able to write it,,,

请先登录，再进行评论。

Answer 3

Walter Roberson 2013-1-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59742-how-to-write-data-to-xls-sheet#answer_72223

在 MATLAB Online 中打开

value_F = [0.1,0.2,0.3,0.4,0.5,0.6];

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Arun Badigannavar 2013-1-24

for making simple,,i have shown some data for value_F here,,,but actually value_F is coming from workspace,,around hundred values i will get it,,how to write those

请先登录，再进行评论。