Here is the code:

(*Import data from a 2 MB Excel file*)

(*First increase memory for large Excel files*)

<< JLink`;


ReinstallJava[CommandLine -> "java", JVMArguments -> "-Xmx2048m"];

(*Now import the dataset*)


data = Import["dataset.xlsx"][[1]];


This code works fine in 10.3.1, but hangs in 10.4.0. Why???

  • 1
    $\begingroup$ Please provide an example Excel file that exhibits the problem. $\endgroup$ – Szabolcs Mar 29 '16 at 21:33
  • $\begingroup$ I have not been able to learn how to upload the Excel file. Any tips? $\endgroup$ – Michael B. Heaney Mar 30 '16 at 0:05
  • 1
    $\begingroup$ @Michael Just upload it to any filehosting like sendspace.com . $\endgroup$ – Alexey Popkov Mar 30 '16 at 2:20
  • $\begingroup$ Thanks for the tip. I just uploaded the example Excel file to sendspace.com. The file is named dataset.xlxs, and the description is "Michael for MMA Stack Exchange." $\endgroup$ – Michael B. Heaney Mar 30 '16 at 5:25
  • 2
    $\begingroup$ @Michael You should publish here the URL you got after uploading the file, not the file name. $\endgroup$ – Alexey Popkov Mar 30 '16 at 6:13

From Wolfram support: the reason 10.4.0 cannot import the excel file: the command ReinstallJava[CommandLine -> "java", JVMArguments -> "-Xmx2048m"]; is incorrect for 10.4.0. The correct command is: ReinstallJava[JVMArguments -> "-Xmx2048m"];.


Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.