How to read data from Excel sheets?

3 次查看（过去 30 天）
Leonardo Wayne
Leonardo Wayne 2016-3-31
评论： Leonardo Wayne 2016-4-5
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?

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

采纳的回答

Jan
Jan 2016-3-31
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.

更多回答（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