Clear Filters
Clear Filters

update the column headng by readin the excel file

4 views (last 30 days)
How to update the column heading of a cell vector which holds the combination?

Accepted Answer

Star Strider
Star Strider on 14 Jul 2023
Edited: Star Strider on 14 Jul 2023
If you want the variable names, first:
T1 = readtable('YourFile.xlsx', 'VariableNamingRule','preserve')
then:
ColumnHeadings = T1.Properties.VariableNames;
then for example:
FirstHeading = ColumnHeadings{1};
to return the first heading (variable name).
EDIT — (14 Jul 2023 at 15:27)
Use the sortrows function —
% figure
% imshow(imread('2023-07-14_13h06_04.png'))
data = readtable('Book2.xlsx', 'VariableNamingRule','preserve')
data = 6×6 table
No Components DescriptioninGUI Parameters Value1 Value2 __ __________ __________________________ __________ ______ ______ 1 {'bb'} {'Length' } {'L' } 80 110 2 {'bb'} {'Width' } {'W' } NaN NaN 3 {'bb'} {'thickness' } {'T' } 1.6 2 4 {'bb'} {'height above the plate'} {'HA'} NaN NaN 5 {'bb'} {'height below the plate'} {'HB'} NaN NaN 6 {'bb'} {'edge width' } {'CE'} NaN NaN
emptyRows = all(ismissing(data),2);
data(emptyRows,:) = [];
variable = data.Parameters;
values = {};
for i = 1:size(data, 1)
values{i} = table2array(data(i, 5:end));
values{i}(all(ismissing(values{i}),2),:) = [];
end
% remove empty cell
values = values(~cellfun(@isempty,values));
combinations = combvec(values{:})';
combinations = sortrows(combinations,1); % <— ADDED
Lv = ~all(ismissing([data.Value1 data.Value2]),2); % <— ADDED
p = variable(Lv);
comitable= array2table(combinations);
comitable.Properties.VariableNames = p(1:size(combinations,2))
comitable = 4×2 table
L T ___ ___ 80 1.6 80 2 110 1.6 110 2
EDIT — (14 Jul 2023 at 15:57)
Added ‘Lv’ (and references to it) to select the correct values of ‘p’.
  17 Comments
PA
PA on 27 Jul 2023
Edited: PA on 27 Jul 2023
do You know how can i convert this combinations from a cell array to a vector keeping the text entries .
{'50'} {'15'} {'Name'}
{'75'} {'15'} {'Name'}
{'50'} {'10'} {'Age' }
{'75'} {'10'} {'Age' }
{'50'} {'15'} {'Age' }
{'75'} {'15'} {'Age' }
{'50'} {'10'} {'Name'}
{'75'} {'10'} {'Name'}
i tried to use str2doublr but i get this
c =
50 15 NaN
75 15 NaN
50 10 NaN
75 10 NaN
50 15 NaN
75 15 NaN
50 10 NaN
75 10 NaN
Star Strider
Star Strider on 27 Jul 2023
Mixed numeric and text can only be combined in a cell array or a table, and a string array is another option (although I am not certain that it is much of an improvement over the cell array here, other than with respect to indexing). The cell2table function might be an option.
Perhaps one of these —
C = {{'50'} {'15'} {'Name'}
{'75'} {'15'} {'Name'}
{'50'} {'10'} {'Age' }
{'75'} {'10'} {'Age' }
{'50'} {'15'} {'Age' }
{'75'} {'15'} {'Age' }
{'50'} {'10'} {'Name'}
{'75'} {'10'} {'Name'}};
T1 = cell2table(C)
T1 = 8×3 table
C1 C2 C3 ______ ______ ________ {'50'} {'15'} {'Name'} {'75'} {'15'} {'Name'} {'50'} {'10'} {'Age' } {'75'} {'10'} {'Age' } {'50'} {'15'} {'Age' } {'75'} {'15'} {'Age' } {'50'} {'10'} {'Name'} {'75'} {'10'} {'Name'}
Text = string(C(:,3));
T2 = array2table(cellfun(@str2double,C(:,[1 2])), 'VariableNames',{'N1','N2'});
T2 = addvars(T2, Text)
T2 = 8×3 table
N1 N2 Text __ __ ______ 50 15 "Name" 75 15 "Name" 50 10 "Age" 75 10 "Age" 50 15 "Age" 75 15 "Age" 50 10 "Name" 75 10 "Name"
S = [cellfun(@str2double,C(:,[1 2])) string(C(:,3))]
S = 8×3 string array
"50" "15" "Name" "75" "15" "Name" "50" "10" "Age" "75" "10" "Age" "50" "15" "Age" "75" "15" "Age" "50" "10" "Name" "75" "10" "Name"
.

Sign in to comment.

More Answers (1)

Image Analyst
Image Analyst on 14 Jul 2023
You forgot to attach your workbook, and forgot to say what kind of variable you want to work with in MATLAB (table, cell array, double). Cell arrays don't have column headings unless you mean the first row of the cell array. If you have the first row be a string, and subsequent rows have numbers, then you'd be best off using a table instead of a cell array.
t = readtable(yourWorkbookFileName)
If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!