MATLAB: Import xlsx file in workspace (sheet has strings and numbers)

importing excel datastrings

I want to import an excel sheet in MATLAB, which has strings on the first row & some subsequent rows as well. I have imported the sheet, but only the numbers are highlighted whereas the string row is indicating as NaN. Kindly help me with this.

Best Answer

[num, txt, raw] = xlsread('YourSheet.xlsx');
then "num" will contain the fields interpreted as numbers, "txt" will contains fields interpreted as text, and "raw" will contain uninterpreted fields.
Related Question