exporting to excel fail, false table size.

2018 1 28
1 个回答
更新时间：2018 1 28
7 次查看（30 天）

0 个投票

hello, i am trying to export a table to excel file. my table is 2027x10 in size. matlab give me an error saying "Error using writetable (line 124) Requested 2027x3075252 (46.4GB) array exceeds maximum array size preference. Creation of arrays greater than this limit may take a long time and cause MATLAB to become unresponsive. See array size limit or preference panel for more information."
can someone help me figure this out?

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Star Strider
Star Strider 2018-1-28
It would help to see the code you use to construct your ‘table’.
Is it actually a table (link) data type, or is it a cell array?

请先登录，再进行评论。

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

回答（1 个）

shahaf peleg
shahaf peleg 2018-1-28

0 个投票

hi thank you for your reply, i realized that some of the fields in the struct where actually arrays (jpg images). i removed those fields and then convert the struct to table and exported to excel. work like it should....thank you anyway!

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by