Read excel file with Matlab
Show older comments
Hello,
I have excel file with three columns "Time", "Altitude, And "Shadow length" that I want to read in Matlab. I tried this commands below, however, the column "Time" format change to decimal number. What can I do to keep the time format the same?
Thank you!
T = readtable('Shadedata.xlsx');
opts = detectImportOptions('Shadedata.xlsx');
preview('Shadedata.xlsx',opts)
Accepted Answer
One option is to use the datetime 'ConvertFrom' name-value pair. For the ‘value’ argument, both 'excel' and 'posixtime' work, with 'excel' appearing to be correct (in that it gives 15-minute intervals) —
% F = fileread('Shadedata.xlsx')
% C = readcell('Shadedata.xlsx')
T = readtable('Shadedata.xlsx', 'VAriableNamingRule','preserve')
T1 = T;
T1.Time = datetime(T1.Time, 'ConvertFrom','excel')
T2 = T;
T2.Time = datetime(T2.Time, 'ConvertFrom','posixtime')
Choose the result that makes the best sense.
.
6 Comments
Sanley Guerrier
on 18 Aug 2023
One possible way to offset the data to that desired date is this:
T = readtable('Shadedata.xlsx', 'VariableNamingRule', 'preserve');
T1 = T;
offset = exceltime(datetime(2023, 2, 10));
T1.Time = T1.Time + offset;
T1.Time = datetime(T1.Time, 'ConvertFrom', 'excel')
Sanley Guerrier
on 18 Aug 2023
As always, my pleasure!
I don’t see anything that directly addresses that problem ('PivotYear' would only change the year) and dateshift doesn’t appear to provide the necessary options.
So, I improvised —
T = readtable('Shadedata.xlsx', 'VAriableNamingRule','preserve')
T.Time = datetime(T.Time, 'ConvertFrom','excel')
[h,m,s] = hms(T.Time); % Get Time Data
T.Time = datetime([repmat([2023 2 10],numel(h),1) h m s]) % Create New Dates & Times
DI = cumsum([0; diff(hour(T.Time))<0]); % Check For Midnight Rollover
T.Time = T.Time + days(DI) % Increment Days For Midnight Rollovers
All the times are the same day here, however I included code that will increment the days in the event other data sets would have a midnight rollover. (I have used this approach with other problems.)
.
Sanley Guerrier
on 18 Aug 2023
Star Strider
on 18 Aug 2023
As always, my pleasure!
More Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
