read string from excel file
64 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi, I want to read text saved in Data sheet and display it on static text (GUI) . I am using this code but its not working:
Cell_Type=xlsread('G:\Data Sheet\Data sheet.xlsx','Sheet1','K4'); %where (K4) cell is wanted text
set(handles.text24,'string',Cell_Type);
what can I do to read it ?? please advice....
0 Kommentare
Antworten (3)
Walter Roberson
am 29 Mai 2012
When you use xlsread() with only one output argument, the output is numeric. You need to use xlsread() with at least two output arguments and use the second one as the text string
0 Kommentare
GOPI
am 19 Jan. 2017
I have some question - How to extract some rows from a Excel file by string matching?
Example: node_14] t=0.000640 START CCA CW = 2
node_20] t=0.000640 START CCA CW = 2
node_14] t=0.000768 CCA EXPIRES -----------> CHANNEL IDLE
node_20] t=0.000768 CCA EXPIRES -----------> CHANNEL IDLE
node_14] t=0.000960 START CCA CW = 1
node_20] t=0.000960 START CCA CW = 1
node_2] t=0.000960 START CCA CW = 2
node_16] t=0.000960 START CCA CW = 2
From this file I want to extract only the rows which started with node_14. Please suggest some tricks.
1 Kommentar
Samer Husam
am 30 Mai 2012
1 Kommentar
Walter Roberson
am 5 Dez. 2015
[~, txt] = xlsread('G:\Data Sheet\Data sheet.xlsx','Sheet1','K4'); %where (K4) cell is wanted text
Cell_Type = txt{1};
set(handles.text24,'string',Cell_Type);
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!