Issue with reading text value from a cell in MS Excel using readmatrix
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Subraya Krishna Bhat
am 8 Aug. 2022
Kommentiert: Subraya Krishna Bhat
am 9 Aug. 2022
I am trying to read a text data in a cell in Excel to a variable in Matlab using the "readmatrix" command. I am using the following syntax.
readmatrix("ABC.xlsx","Sheet",'S1',"Range",'N1:N1')
But it is reading NaN value instead of the actual text. If I change the cell location (range) to another cell containing numeric data it is reading correctly. But only in case of text data this is happening. Kindly help me in resolving this issue. Thank you.
0 Kommentare
Akzeptierte Antwort
Jonas
am 8 Aug. 2022
if i am not mistaken, readmatrix expects numbers for each entry, so the numbers can be but into a matrix. if your data contains numbers and text (multiple characters per cell), try readcell instead
Weitere Antworten (0)
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!