MATLAB Answers

Reading a table in excel

1 view (last 30 days)
Alexandra Philip
Alexandra Philip on 12 Aug 2020
Commented: Walter Roberson on 12 Aug 2020
I am having some trouble with reading a table in excel and then extracting specific rows.
I first use:
filenameEGI='Copy of EGI Yield Data July 2020 7_30_20.xlsx'
fileread=readtable(filenameEGI)
columnData=fileread(2056:2098,:)
In effort to read rows 2056 to 2098. However in certain columns NaN is bein displayed and I would like whatever was in that excel cell to display instead.
Where the NaN displayed, in the excel cell it displayed words and file folder links.
Any suggestions or application of corrections?

  4 Comments

Show 1 older comment
hosein Javan
hosein Javan on 12 Aug 2020
not sure. but I think table does not support strings. use csvread instead.
Walter Roberson
Walter Roberson on 12 Aug 2020
table does support characters, but csvread() does not.
Columns that contain a mix of numbers and text will generally be detected as text, but that depends upon the release and the fraction of text. Older releases that did not automatically use detectImportOptions were more likely to guess that a file with leading numbers would never have text; detectImportOptions goes a better job of figuring out columns.
Walter Roberson
Walter Roberson on 12 Aug 2020
You could consider using readcell() : the entries that can be converted to numeric will be converted, but will be left in individual cells.
You can then use cellfun(@isnumeric) or similar to locate non-numeric entries.

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!