How to read data from Excel sheets?

Question

Leonardo Wayne 2016-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276327-how-to-read-data-from-excel-sheets

评论： Leonardo Wayne 2016-4-5

采纳的回答： Jan

在 MATLAB Online 中打开

I have an Excel spreadsheet cell in location S2 that has the example data :

160225MD0004;#2;#13161504900013;#1

These items are followed by only by one or two symbols: for example ;#2 and ;# trailing the first item 160225MD0004. The first symbol will always follow the item to specify order(;#2) and the second symbol is an item separator-see 2nd items doesn't have one since it's the last item. There could be more than 2 items or even one item. I want to read using MATLAB functions the numbers: 160225MD0004 and 13161504900013 only. How can that be done?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2016-3-31

The data format is not clear. "160225MD0004" is not a number.

请先登录，再进行评论。

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

Answer 1

Jan 2016-3-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/276327-how-to-read-data-from-excel-sheets#answer_215815

Perhaps strtok helps you to cut off the string part before the semicolon.

Instead of explaining the Excel-sheet, import the data by xlsread and post the code, which creates the resulting cell explicitly. Then the readersdo not have to guess, how the data looks like.