The xls file looks like this... The first column is the longitude. I want to extract only the number from it. For example, if the array has a value of "84.375E", I want "84.375" in my corresponding array's value and so on. For the column named "time", I want to similarly extract the number (year). For example, if the cell is "Jun-Sep 1990", I want my corresponding array to have a value of "1990".
I tried to load the values myself. I tried this code:
T = readtable('Myxlsx.xlsx',2);
But I got this error:
Error using readtable (line 245)
All parameters must have an associated value.
Then I tried the xlsread command like this:
T = xlsread('Myxlsx.xlsx');
But then only the values from the fourth column got loaded but nothing from the first three columns appeared.