How can i control a uicheckbox based on excel cell value Yes or No

Question

PA 2023-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2008667-how-can-i-control-a-uicheckbox-based-on-excel-cell-value-yes-or-no

编辑： Cris LaPierre 2023-8-16

I have an excel cell value for a parameter to be YES NO. Now i am importing this in my function and then creating folders to store the excel values After that i want to modify my checkbox by the values from excel cell

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rik 2023-8-15

And which part of this process is causing you trouble? Have a read here and here. It will greatly improve your chances of getting an answer. Your current question is a description for a consultant, not a question.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2023-8-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2008667-how-can-i-control-a-uicheckbox-based-on-excel-cell-value-yes-or-no#answer_1287807

See this example: https://www.mathworks.com/help/matlab/ref/uicheckbox.html#buios0i-9

as well as this page: https://www.mathworks.com/help/matlab/ref/matlab.ui.control.checkbox-properties.html#responsive_offcanvas

Basically, you need to programmatically convert your yes/no to true/false, and use that to set the Value property of your checkbox.

11 个评论
显示 9更早的评论隐藏 9更早的评论

Cris LaPierre 2023-8-15

编辑：Cris LaPierre 2023-8-16

在 MATLAB Online 中打开

excel_Y_N.xlsx

At least part of the problem is your table format - you have mixed data types in some of your columns. Since you are not specifing import options, readtable is trying to automatically determine the data type for each column. Since your first row contains number data in columns 4-5, it treats all data in those columns as numbers. Anything that is not a number is convereted to nan, including 'yes' and 'no'.

You will need to treat those columns as text if you want to capture the text values. Just be aware that the numbers will also strings instead of doubles.

% What is currently happening
data = readtable('excel_Y_N.xlsx')
data = 5×5 table
    Var1          Var2               Var3          Var4    Var5
    ____    ________________    _______________    ____    ____

     1      {'distance1'   }    {'d1'         }      5      10 
     2      {'distance2'   }    {'d2'         }    NaN     NaN 
     3      {'distance3'   }    {'d3'         }    NaN     NaN 
     4      {'distance4'   }    {'d4'         }    NaN     NaN 
     5      {'Pi Selection'}    {'Pi.Autocalc'}    NaN     NaN 
% Specifying import options
opts = detectImportOptions("excel_Y_N.xlsx");
opts = setvartype(opts,4:5,"string");
data = readtable("excel_Y_N.xlsx",opts)
data = 5×5 table
    Var1          Var2               Var3            Var4         Var5   
    ____    ________________    _______________    _________    _________

     1      {'distance1'   }    {'d1'         }    "5"          "10"     
     2      {'distance2'   }    {'d2'         }    <missing>    <missing>
     3      {'distance3'   }    {'d3'         }    <missing>    <missing>
     4      {'distance4'   }    {'d4'         }    <missing>    <missing>
     5      {'Pi Selection'}    {'Pi.Autocalc'}    "Yes"        "No"     

PA 2023-8-16

编辑：PA 2023-8-16

thanks and yeah it has mixed data type therefore i had to create the combination using nested loop comb =

8×3 cell array

{'5' } {'9'} {'Yes'}

{'10'} {'9'} {'Yes'}

{'5' } {'9'} {'No' }

{'10'} {'9'} {'No' }

{'5' } {'9'} {'No' }

{'10'} {'9'} {'No' }

{'5' } {'9'} {'Yes'}

{'10'} {'9'} {'Yes'}

then convert this output to string and double

combinationOutput =

8×3 table

d1 d3 Pi.Autocalc

__ __ ___________

5 9 "No"

5 9 "Yes"

10 9 "No"

10 9 "Yes"

The basic idea is importing the excel file creating combination storing this new combinations in a new variant and then exporting

And then creating combination of the excel cell and then calling the

objDesign_k = objDesign;

objDesign_k.PI.Autocalc = objDesign.PI.Autocalc;

checkboxdata = strcmp(objDesign.PI.Autocalc;,"YES")

I want to read this combinations values and change my interface accordingly for example in the first case 5 9 "No" then the value of d1 shall assign to 5 d3 to 9 and the checkbox need to be uncheck as it is No and vice versa if the combination has Yes in it and i have no idea how to do it. Please help me!

PA 2023-8-16

i just added a new value'9' to the parameter d3. And can you tell me how can i check and uncheck the ui check box with the tableYES or NO with the code i shared here