MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn moreOpportunities for recent engineering grads.

Apply TodayTo resolve issues starting MATLAB on Mac OS X 10.10 (Yosemite) visit: http://www.mathworks.com/matlabcentral/answers/159016

Asked by Arun Badigannavar on 24 Jan 2013

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

*No products are associated with this question.*

Answer by Image Analyst on 24 Jan 2013

Accepted answer

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)

Answer by Walter Roberson on 24 Jan 2013

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

Arun Badigannavar on 24 Jan 2013

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

Answer by Sachin on 24 Jan 2013

Check the type of workspace output variable using "whos ,var_name". It could be a problem with type of data being written in excel.

Answer by Jing on 24 Jan 2013

Edited by Jing on 24 Jan 2013

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');

Arun Badigannavar on 24 Jan 2013

No am unable to write both string and double value to xls sheet

## 0 Comments