How to write a large matrix to a comma separated file

3 views (last 30 days)
Hello,
I've got a huge matrix (20000 x 3000) and I want to write it to a csv file.
Until now, where the size of my matrices was 20000 x 1000 I was using the command
csvwrite('file1.dat',matrix1)
But now, the file1 is impossible to open.
Any ideas?
Thanks
  2 Comments
Walter Roberson
Walter Roberson on 27 Nov 2013
Edited: Walter Roberson on 27 Nov 2013
"impossible to open" with which program?
Excel 2003 and previous were limited to 256 columns; Excel 2007 changed the limit to 16384 columns.
Are you trying to read the file with csvread() or with xlsread() ? Are you using MS Windows and do you have Excel installed on your system? Are you using a 32 bit version of MATLAB and are you getting a message about running out of memory ?
Christina
Christina on 28 Nov 2013
Hi Walter,
Thanks for the response. My system is 64 bit, yes I do have Windows and I was trying to open that file, either with Excel 2007, or with Notepad ++. Anyway, I won't continue working with that, as it takes lots of time.
Thank you for your reply anyway.

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!