Reading large Excel array into MATLAB

0
votes

So I have a huge excel file with 210 columns from(A all the way to CK)-Each of these columns have 80000-300000 values.I want to read this into a MATLAB array.I have two problems:

1.Is there any way that I can loop through the letters iteratively(from A to CK)?

2.When I try to read the file as a whole it says no storage-but I am able to create a matrix of ones of size-300000*210....So Im a bit puzzled and dont know what to do..??

Thanks!!

2
arraysexcelmatlabxlsread
Please show what you tried. Also make sure your data is all numeric if you compare its storage size to a matrix of ones. - Dennis Jaheruddin

2 Answers

1
votes

Save in the .csv format from EXCEL, then use load -ascii in matlab.

0
votes

You can loop through the Excel column with the option xlRange of xlsread (doc).

And both the output num = xlsread(...) and [num,txt,raw] = xlsread(...) duplicate the information being read in several variables (type edit xlsread in the command window).