Using readtable() for Excel file where only one column has mixed numbers and text

15 次查看（过去 30 天）
Douglas Anderson
Douglas Anderson 2022-4-7
编辑： Stephen23 2022-4-7
Hello,
When using readtable() for an Excel file, there are thirteen columns, some of which are only text and most of them only numbers. The first column, and identifier, sometimes is integers and sometimes text. If it starts out integers, the text ones become NaN.
Is there a way to read only one column as text even if it starts out as number? I'd rather not read it ALL in as text and then convert the rest one-by-one. Looked through the readtable() documentation and didn't see this.
Thanks.
Doug Anderson

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

采纳的回答

Stephen23
Stephen23 2022-4-7
编辑：Stephen23 2022-4-7
Of course you can specify the class, the simplest approach is probably via DETECTIMPORTOPTIONS and SETVARTYPE:
fnm = 'filename.xlsx';
opts = detectImportOptions(fnm);
opts = setvartype(opts,1,'string');
tbl = readtable(fnm,opts)

更多回答（0 个）

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by