MATLAB Answers

How can I convert a large .mat file (> 400 MB) into an excel file or csv file?

8 views (last 30 days)
Karl-Heinz Fleischer
Karl-Heinz Fleischer on 31 May 2011
How can I convert a large .mat file (> 400 MB) into an excel file or csv file?
  3 Comments
D G
D G on 31 May 2011
have you considered splitting it up into several files, then joining them via another program?

Sign in to comment.

Answers (3)

Andreas Goser
Andreas Goser on 31 May 2011
It looks like you have the code already, but are looking for suggestions how to avoid memory errors. I have two:
1. Convert to SINGLE or other memory saving data type.
2. Use decimation of data, e.g. take only every 2nd, 10th, etc. data point.
I often observe that users create more data than they really need just "because it is possible". I can't assess your project, but this is a general observation.
If you have control over the Simulink model, you can apply those steps even within Simulink for double benefits.
There was a suggestion about splitting up the file - in this case doing it for all 24 channels can be good.
Just to make sure: You have 64 Bit MATLAB on a 64 system?

Todd Flanagan
Todd Flanagan on 31 May 2011
You are probably getting this error:
??? Error using ==> xlswrite at 211
Excel returned: Error: Object returned error code: 0x800A03EC.
This comes from the Excel activex interface. The best approach to work around this is to write your worksheet in chunks in a loop. There is an example of that here.

Fangjun Jiang
Fangjun Jiang on 31 May 2011
There is a limit on the number of rows and columns in an Excel file. 65536 rows and 256 columns for MS Office 2003. 1,048,576 rows by 16,384 columns for Office 2007. Transpose your matrix and try csvwrite(). If not working, try to use fopen(), fprintf() to write your matrix one line at a time. Sounds like you need to write more then 2 million times.

Community Treasure Hunt

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

Start Hunting!

Translated by