Error using load Number of columns on line 2 of ASCII file
29 views (last 30 days)
Show older comments
Hello everybody !
I want to make a prediction by using Extreme learning Machine (ELM), but i encountered a problem when reading data from my file excel. My data are in the following form:
Column 1: contains the date format (dd / mm / yyyy hh: mm)
Column 2: contains numeric values.
Here is the code :
train_data=load(TrainingData_File);
T=train_data(:,1)';
P=train_data(:,2:size(train_data,2))';
clear train_data;
Here is the error :
Error using load
Number of columns on line 2 of ASCII file SolarData_training.xlsx must be the same as previous lines.
I use Matlab R2014 a.
Thank you so much !
0 Comments
Accepted Answer
Star Strider
on 16 Jan 2017
It is best to not use the load function with Excel files. Use xlsread to import your data. Use the datenum function to convert your date and time strings to date numbers and other formats.
0 Comments
More Answers (4)
Niels
on 16 Jan 2017
Edited: Niels
on 16 Jan 2017
matlab tries to create a matrix with 2 rows. obviously your second row has more or less colums than the first row, so your matrix looks like
A =
1 0 2
3 4
such a matrix does not exist, thats why an error returns
use xlsread and the missing colums will be filled with NaNs
0 Comments
Walter Roberson
on 16 Jan 2017
I would suggest readtable() for this purpose. As you are using R2014a, the times will not be converted to datetime objects; they will either show up as excel date numbers or as strings, depending on your operating system.
If you end up with an excel date number, then if you have the Finance toolbox you can use https://www.mathworks.com/help/finance/x2mdate.html
If you do not have that toolbox, then you can add datenum() of Dec 31 1899 to the date. But you have to be careful; see https://www.mathworks.com/matlabcentral/answers/254-converting-excel-serial-number-of-time-to-hh-mm-ss-format#answer_353
0 Comments
Hamza Ali
on 16 Jan 2017
3 Comments
per isakson
on 17 Jan 2017
Edited: per isakson
on 17 Jan 2017
"However, I get only one column that the numeric values, but the one containing the date is unrecoverable."   I guess, your problem is related to the difference between the default reference dates of Excel and Matlab.
MATLAB serial date number January 0, 0000
Excel for Windows January 1, 1900
Excel for the Macintosh January 2, 1904
Walter Roberson
on 17 Jan 2017
It is worse than that, Excel for Windows thinks Feb 29 1900 was a leap year but it was not, so the adjustment depends on whether your dates refer to dates after Feb 28 1900.
See Also
Categories
Find more on Data Import from MATLAB 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!