MATLAB: Creating Headers for xlswrite

headerxlswrite

Hello,

I am trying to create headers for data I am exporting from my code to excel. I want to have matlab print "ROI #1" in cell A2 of excel, "ROI #2" in A3, "ROI #3" in A4, etc. Here is what I have so far:

roi_count(1:(length(props{1})),1) = {'ROI #'}; 
roi_label(:,1) = num2cell(1:length(props{1}));
row_header = cellfun(@(x,y) [x y],roi_count,roi_label,'un',0); 
range = 'A2'
xlswrite('advanced_test.xlsx',row_header,'Sheet1',range);

This gets close to what I want, however, the code prints "ROI #[]" in each cell within excel. I feel like I need to add a convert to string or something like that… unsure how to proceed. Please help!

Thanks 🙂

Best Answer

row_header = cellstr( num2str( (1:length(props{1})).', 'ROI #%d' ) ) .'

If you have R2017a or later you can use

row_header = cellstr( "ROI #" + (1:length(props{1})) );

If you have R2016b you can use

row_header = cellstr( string('ROI #') + (1:length(props{1})) );

Related Solutions

MATLAB: Extracting Names from Excel

filename='myData.xlsx';

sheet=1;

xlRange='A1:A1';

% Text fields are stored in cell array txt

[num,txt,raw] =xlsread(filename,sheet,xlRange)

% cell array content indexing to get the string value

winopen(txt{1,1})

MATLAB: How to use XLSWRITE to add row and column labels to the MATLAB matrix when I write it to Excel in MATLAB 7.3 (R2006b)

The following examples illustrate how to use XLSWRITE to add column and row labels to a MATLAB matrix that is written to an Excel file. This can be done either by writing to several sections of the worksheet (Case 1), or by joining the data and labels before writing to the XLS-file (Case 2).

Case 1. Using several XLSWRITE commands:

data=ones(10,4);      %Sample 2-dimensional data

col_header={'Temperature','Pressure','X','Y'};     %Row cell array (for column labels)

row_header(1:10,1)={'Time'};     %Column cell array (for row labels)

xlswrite('My_file.xls',data,'Sheet1','B2');     %Write data
xlswrite('My_file.xls',col_header,'Sheet1','B1');     %Write column header
xlswrite('My_file.xls',row_header,'Sheet1','A2');      %Write row header

Case 2. Using one XLSWRITE command:

data=ones(10,4);     %Sample 2-dimensional data
data_cells=num2cell(data);     %Convert data to cell array
col_header={'Temperature','Pressure','X','Y'};     %Row cell array (for column labels)
row_header(1:10,1)={'Time'};     %Column cell array (for row labels)
output_matrix=[{' '} col_header; row_header data_cells];     %Join cell arrays
xlswrite('My_file.xls',output_matrix);     %Write data and both headers

Best Answer

Related Solutions

MATLAB: Extracting Names from Excel

MATLAB: How to use XLSWRITE to add row and column labels to the MATLAB matrix when I write it to Excel in MATLAB 7.3 (R2006b)

Related Question