MATLAB: How can i write a matrix into a single row of excel sheet

matrix into row

how can i write a matrix into a single row of excel sheet? lets say, i have a matrix of 10*2 and i have to write this matrix in excel as A1 to T1. please help me out as early as possible.i am supposed to make a feature file in excel using the features extracted from a image in a matrix.

Best Answer

Simply reshape your matrix into a row vector before passing it to xlswrite:

xlswrite(filename, reshape(yourmatrix, 1, []), sheetname, 'A1')

Related Solutions

MATLAB: Excel Range in specifies Sheet.

Hi, Just activating the particular sheet before adding range will solve it.

ex = actxserver('excel.application');

ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));

Sheets = Excel.ActiveWorkBook.Sheets;

Sheet3 = get(Sheets, 'Item', 'Sheet3');

Sheet3.Activate

ex.Range('A3').Name = 'RangeName';

ex.ActiveWorkbook.Save

ex.Quit

ex.release

MATLAB: How to write data to xls sheet

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)

Best Answer

Related Solutions

MATLAB: Excel Range in specifies Sheet.

MATLAB: How to write data to xls sheet

Related Question