试用软件

strings and numbers from excel

5 次查看（过去 30 天）

显示更早的评论

Tomas Iesmantas 2011-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8092-strings-and-numbers-from-excel

采纳的回答： Fangjun Jiang

Hi, I need to read table from excel. This table are filled with numers and strings and some cells are empty. Is there easy way to read such table in one matrix? Because now matlab just creates to matrices: one with strings and another with numbers and NaN's where strings used to be.

Thanks in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Fangjun Jiang 2011-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8092-strings-and-numbers-from-excel#answer_11119

在 MATLAB Online 中打开

Use the third returning argument of xlsread()

[NUMERIC,TXT,RAW]=XLSREAD(FILE)

I always prefer this way because then I can process the RAW information as I need. Some helpful functions are, isnan(), isnumeric()

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

更多回答（1 个）

the cyclist 2011-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/8092-strings-and-numbers-from-excel#answer_11115

I have used the following entry from the File Exchange with success:

http://www.mathworks.com/matlabcentral/fileexchange/10946-readtext

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

标签

产品

MATLAB

Community Treasure Hunt

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

Translated by

试用软件