Prev: simultaneous parameter variation
Next: permutation
From: Ashish on 27 Apr 2010 01:30
Hi,

I have a xlsx file with 3,00,000 rows. I need to import that to matlab. I have tried xlsread, csvread, importdata, csv2struct but i am unable to load more than 65536 rows at one time.

Kindly help me how can i import all the data at one time.

Regards,
Ashish Gupta
From: ade77 on 27 Apr 2010 12:34
"Ashish " <ashish.gupta(a)edelcap.com> wrote in message <hr5spe$84q$1(a)fred.mathworks.com>...
> Hi,
>
> I have a xlsx file with 3,00,000 rows. I need to import that to matlab. I have tried xlsread, csvread, importdata, csv2struct but i am unable to load more than 65536 rows at one time.
>
> Kindly help me how can i import all the data at one time.
>
> Regards,
> Ashish Gupta

Depends on the version of MATLAB you have. If you have version 2008 or below, then you will have to upgrade to version 2009 or 2010.
From: Ashish on 29 Apr 2010 05:10
I am using R2009b+ version

Regards,
Ashish Gupta

"ade77 " <ade100a(a)gmail.com> wrote in message <hr73lt$coh$1(a)fred.mathworks.com>...
> "Ashish " <ashish.gupta(a)edelcap.com> wrote in message <hr5spe$84q$1(a)fred.mathworks.com>...
> > Hi,
> >
> > I have a xlsx file with 3,00,000 rows. I need to import that to matlab. I have tried xlsread, csvread, importdata, csv2struct but i am unable to load more than 65536 rows at one time.
> >
> > Kindly help me how can i import all the data at one time.
> >
> > Regards,
> > Ashish Gupta
>
> Depends on the version of MATLAB you have. If you have version 2008 or below, then you will have to upgrade to version 2009 or 2010.
From: ade77 on 29 Apr 2010 19:30
"Ashish " <ashish.gupta(a)edelcap.com> wrote in message <hrbidc$p7q$1(a)fred.mathworks.com>...
> I am using R2009b+ version

Ashish,

I use MATLAB 2010a, and I do not have problems with loading 500,000 rows.
Although I never used 2009a or 2009b version. I used 2008b, and I know it does not work with 2008b, but from the documnetaion I have read it should work with version 2009a or 2009b.

One thing I might suspect is if you have Excel 2003 and 2007 both installed on your computer.
Also, try and put the extension "xlsx".... data = xlsread('myfile.xlsx').

If the above are not the problems, and you regularly work with both excel, and MATLAB, I will advise you reinstall the excel 2007.
 | 
Pages: 1
Prev: simultaneous parameter variation
Next: permutation