MATLAB: How to store the column names for each numerical values for respective rows in an array

findindexingmatrix array

I'd like to get from a raw matrix like this:

several cell arrays of strings like this:

   One = 'A'    'C'    'D'    'F'
   Two = 'B'    'G'

How could I do this?

Best Answer

You can try something like this.

data=readtable('Name.xlsx','sheet','test')
Headers=data.Properties.VariableNames(2:end);
One=Headers(data{1,2:end}==1)
Two=Headers(data{2,2:end}==1)
%etc..

Related Solutions

MATLAB: Concatenating characters in different column to a string

['a' 'b' 'c' 'd' 'e'] is not a 1 x 5 array of strings: it is a single string of length 5, 'abcde', exactly as you want.

{'a' 'b' 'c' 'd' 'e'} on the other hand would be a 1 x 5 cell array of strings. You can convert this cell array to a single string by using cell2mat()

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

This bug has been fixed in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

The following provides an example of opening an existing Excel file named example.xls and proceeding to write and read with it:

% Specify file name
file = 'D:\Applications\MATLAB701\work\example.xls'; % This must be full path name
% Open Excel Automation server
Excel = actxserver('Excel.Application');
Workbooks = Excel.Workbooks;
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook=Workbooks.Open(file);
% Specify sheet number, data, and range to write to 
sheetnum=1;
data=rand(4);  % use a cell array if you want both numeric and text data
range = 'F10:I13';
% Make the first sheet active
Sheets = Excel.ActiveWorkBook.Sheets;
sheet1 = get(Sheets, 'Item', sheetnum);
invoke(sheet1, 'Activate');
Activesheet = Excel.Activesheet;
% Put MATLAB data into Excel
ActivesheetRange = get(Activesheet,'Range',range);
set(ActivesheetRange, 'Value', data);
% Here you might manipulate the data in Excel
% Now read the data from the sheet; you could specify a new range here
Range = get(Activesheet,'Range',range);
out = Range.value;
% Save file
invoke(Workbook,'Save')
% Close Excel and clean up
invoke(Excel,'Quit');
delete(Excel);
clear Excel;

Best Answer

Related Solutions

MATLAB: Concatenating characters in different column to a string

MATLAB: How to open an existing Excel file and communicate with it using ActiveX

Related Question