Reading a table in excel

1 次查看（过去 30 天）
Alexandra Philip
Alexandra Philip 2020-8-12
评论： Walter Roberson 2020-8-12
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 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2020-8-12
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 2020-8-12
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.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by