I have already set it to be 4GB.

ReinstallJava[JVMArguments -> "-Xmx4096m"]

However, when exporting a dataset to Excel sheet, I still get the following: enter image description here

Very frsutrating after a long wait and still getting this error. My laptop does have 32G of RAM. But is there a way to figure out how much to set in advance (instead of setting to the limit)?


  • $\begingroup$ Hard to say without ans. $\endgroup$ – Kuba Nov 3 '17 at 6:43
  • 1
    $\begingroup$ At the very least, what does ByteCount[Prepend[ans, Range[85]]] return? $\endgroup$ – J. M. will be back soon Nov 3 '17 at 6:55
  • $\begingroup$ @J.M. Wow, it's 519284064. No idea it's that big! $\endgroup$ – Chen Stats Yu Nov 3 '17 at 14:47
  • 2
    $\begingroup$ Then, can you try setting to 8 GB (ReinstallJava[JVMArguments -> "-Xmx8192m"])? $\endgroup$ – J. M. will be back soon Nov 3 '17 at 14:50
  • 1
    $\begingroup$ If you do not mind using NETLink (which seems way more efficient than JLink in the case of exporting large Excel files), try my bigExport function posted here: community.wolfram.com/groups/-/m/t/1163363 $\endgroup$ – Rolf Mertig Nov 3 '17 at 22:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.