How to read data from Excel sheets?
5 views (last 30 days)
I have an Excel spreadsheet cell in location S2 that has the example data :
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 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.