How to import Pushbutton results into Excel file?

2 vues (au cours des 30 derniers jours)
Linda Hornakova
Linda Hornakova le 20 Nov 2017
Hello, I am new to MATLAB. I have two push buttons in my GUI- OK / N-OK a I need to import ok/n-ook into excel file depending which button is pushed. Can anyone help me please?
  2 commentaires
Jan
Jan le 20 Nov 2017
Which data do you want to "import"?
Linda Hornakova
Linda Hornakova le 20 Nov 2017
I need to be written in the excel sheet ok or n-ok. I have several picutes which I upload to my GUI and 2 push buttons in the GUI: OK a N-OK. And as an output I need excel file with 2 columns: picture (1-20) and results (OK or N-OK). I hope I make sense at least little bit. It is my first time using it, so sorry for any misunderstandings. Thank you

Connectez-vous pour commenter.

Réponses (1)

PG_Dev
PG_Dev le 21 Nov 2017
Modifié(e) : PG_Dev le 24 Nov 2017
Linda
If I understand your question correctly, you can use a table in the GUI with the 2 columns (using uitable). You can enter the picture names on one column and then update OK/N-OK by pressing pushbuttons. And then you can export the table contents to an Excel sheet using another push button(using xlswrite)
Regards
PG
  1 commentaire
Linda Hornakova
Linda Hornakova le 30 Nov 2017
Modifié(e) : Linda Hornakova le 30 Nov 2017
Thank you, very good idea.
I am currently using these codes, where 0=OK, 1=S-OK and -1=KO. But is at able instead of the numbers having the letters in the column?
>> % --- Executes on button press in OK.
>> function OK_Callback(hObject, eventdata, handles)
>> % hObject handle to OK (see GCBO)
>> % eventdata reserved - to be defined in a future version of MATLAB
>> % handles structure with handles and user data (see GUIDATA)
>> data = get(handles.uitable1, 'data');
>> data(end+1,:) = 0;
>> set(handles.uitable1,'data',data)
Is also possible while adding the rows, changing the name of the rows from 1 - n, to eg. A1,A2,A3, etc.?
Thank you!

Connectez-vous pour commenter.

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by