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.
If you have the 2003 version of excel, then it can't handle 200000 rows. that is what is returning the error.
精彩评论