Reading all values as a string from excel file
2 views (last 30 days)
I have an excel file that includes, strings, numbers and time in the format "01:59.00"
When I use xlsread in Matlab to read in the sheet I am currently using [~, ~, alldata] = xlsread... however, my time variables are getting converted to decimals.
Is there any way I am able to keep the time variable or even read it as a string?
Thank you in advance
Stephen23 on 24 Jan 2022
In Excel dates are stored as serial date numbers, so what you are getting is the raw data.
The best solution is to use READMATRIX or READCELL which will (either automagically or with some hints from you) import Excel's serial date numbers as DATETIME objects.
The next option, if you insist on using outdated XLSREAD, is to do that conversion yourself. There are many threads on this forum showing how, the simplest approach is to use DATETIME which has this conversion built in:
N = 39448.25 % Excel serial date number
D = datetime(N,'convertFrom','excel')