MATLAB Answers

How to read data from Excel sheets?

7 views (last 30 days)
Leonardo Wayne
Leonardo Wayne on 31 Mar 2016
Commented: Leonardo Wayne on 5 Apr 2016
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 Comment
Jan
Jan on 31 Mar 2016
The data format is not clear. "160225MD0004" is not a number.

Sign in to comment.

Accepted Answer

Jan
Jan on 31 Mar 2016
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.
  1 Comment
Leonardo Wayne
Leonardo Wayne on 5 Apr 2016
Thanks for your feedback. Apologies for the unclear question.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!