MATLAB: How can i get the numbers from an Excel document? like if we have L/22, and we want to get the number 22 out
Best Answer
[~, ~, raw] = xlsread('somefile.xlsx'); %read raw content of excel file
numtext = regexp(raw, '\d+', 'match', 'once'); %extract 1st sequence of digits of each cell
numbers = cellfun(@str2double, numtext) %convert strings to numbers.
will do it, assuming that the numbers are all integers (otherwise the regular expression has to be more complex).
Alternatively, create a new table in excel with a formula that creates a copy of the data while stripping the non-numeric characters and import that table in matlab.
Best Answer