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

3 次查看（过去 30 天）
Karl-Heinz Fleischer
How can I convert a large .mat file (> 400 MB) into an excel file or csv file?
  3 个评论
显示 1更早的评论
Karl-Heinz Fleischer
Karl-Heinz Fleischer 2011-5-31
it is a large log file from a simulink "to workspace" block.
The command xlswrite brings up cache errors.
the file is for example <24x2107089 double> big.
:)
D G
D G 2011-5-31
have you considered splitting it up into several files, then joining them via another program?

请先登录，再进行评论。

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

回答（3 个）

Andreas Goser
Andreas Goser 2011-5-31
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 2011-5-31
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 2011-5-31
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by