exporting to excel fail, false table size.

11 visualizzazioni (ultimi 30 giorni)
shahaf peleg
shahaf peleg il 28 Gen 2018
Risposto: shahaf peleg il 28 Gen 2018
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 Commento
Star Strider
Star Strider il 28 Gen 2018
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?

Accedi per commentare.

Risposte (1)

shahaf peleg
shahaf peleg il 28 Gen 2018
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!

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by