Search code examples
matlabdata-export

Big-Data export from Matlab to a .csv file

I need to create a big .csv file with say 200,000+ rows and 7 cols. This fails:

a = randn(200000,7) ; xlswrite('hugedata.csv', a) ;

??? Error using ==> xlswrite at 211 Excel returned: Error: Object returned error code: 0x800A03EC.

a = randn(4,3) ; xlswrite('hugedata.csv', a) ; % works perfectly fine.

Comments? Please suggest an alternative code if available. Thanks.

Solution

  • If you have the 2003 version of excel, then it can't handle 200000 rows. that is what is returning the error.