How to write a large matrix to a comma separated file

2 次查看（过去 30 天）

显示更早的评论

Christina 2013-11-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/107765-how-to-write-a-large-matrix-to-a-comma-separated-file

评论： Christina 2013-11-28

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 个评论
显示无隐藏无

Walter Roberson 2013-11-27

编辑：Walter Roberson 2013-11-27

"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 2013-11-28

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.

请先登录，再进行评论。

请先登录，再回答此问题。