xlswrite output size limit

5 次查看（过去 30 天）
Jeremy
Jeremy 2018-7-18
编辑： Walter Roberson 2018-7-18
Good afternoon, MATLAB community. This is an obscure question, but does anyone know what the maximum file size that can be written to Excel using xlswrite?
I have a 14183x2416 cell array (has to be a cell array since there are a combination of characters and numbers), and when I 'whos' the variable name, I find it to be 4.1 GB. I've poured through all the literature I could find regarding writing to Excel from MATLAB, but everything I see talks about the actual cell/matrix size limitation, and from what I can tell, mine is well below that limit. The error I get is:
Error: Not enough storage is available to complete this operation.
I'm using a fairly high-end computer, so I can't imagine it's a hardware issue. To investigate the issue further, I chopped off about 1400 columns and the resulting cell was about 1.7 GB, which wrote to Excel with ease. At this point, the only thing I can think of is to break the big file up into two (or more) smaller files, but there's a way to keep everything in one Excel file, that would be the desired outcome.
The Excel version I'm using is 2010 (corrected; used to say 2016) and the MATLAB version is 2016b if that helps.
Thanks for your time!
  10 个评论
显示 8更早的评论
Harsh
Harsh 2018-7-18
Additionally, looks like the error is coming from Excel when it does not have enough memory. Assuming that you have a large enough memory to handle 4GB+ file sizes, check the task manager for memory usage and close any other programs / applications.
Walter Roberson
Walter Roberson 2018-7-18
编辑：Walter Roberson 2018-7-18
I would interpret that is "disk full".
Or on some Linux server systems, it could be the case that you are running into a ulimit

请先登录，再进行评论。

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

回答（1 个）

Jeremy
Jeremy 2018-7-18
Figured out the issue thanks to OCDER. The version I'm using (Excel 2010) is the 32 bit version, which limits writing to 2 GB. Earlier, I checked the version and it said 64 bit, which is partially why I was so confused. However, never discount the possibility that I'm an idiot, so I checked my home computer instead of the virtual machine I'm using. The VM's version of Excel is the 32 bit version, which accounts for the issue.
Thank you all very much for the help!

类别

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

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by