Everytime I try to use readcell , readtable.. I get one or alll of the following problems:
Numeric columns get merged into one cell array ex : {1.5,2.5} vs them being in two unique cells
Additional columns that dont exist in my csv/xlsx files with 1×1 missing filled in
Nan for string entries
I saw online that a column with text and numeric values dont mix well. Anyone have any suggestions?
I am also trying to find a specific string value index (xdist_mm,Power_watts) for each file to then import the data under each of these headers into a seperate array for analysis. I tried strfind and contains without much sucess)

Thank youEverytime I try to use readcell , readtable.. I get one or alll of the following problems:
Numeric columns get merged into one cell array ex : {1.5,2.5} vs them being in two unique cells
Additional columns that dont exist in my csv/xlsx files with 1×1 missing filled in
Nan for string entries
I saw online that a column with text and numeric values dont mix well. Anyone have any suggestions?
I am also trying to find a specific string value index (xdist_mm,Power_watts) for each file to then import the data under each of these headers into a seperate array for analysis. I tried strfind and contains without much sucess)

Thank you Everytime I try to use readcell , readtable.. I get one or alll of the following problems:
Numeric columns get merged into one cell array ex : {1.5,2.5} vs them being in two unique cells
Additional columns that dont exist in my csv/xlsx files with 1×1 missing filled in
Nan for string entries
I saw online that a column with text and numeric values dont mix well. Anyone have any suggestions?
I am also trying to find a specific string value index (xdist_mm,Power_watts) for each file to then import the data under each of these headers into a seperate array for analysis. I tried strfind and contains without much sucess)

Thank you readtable, readcell MATLAB Answers — New Questions

​