5
$\begingroup$

Here is the code:

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

(*First increase memory for large Excel files*)

<< JLink`;

InstallJava[];

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

(*Now import the dataset*)

Clear[data];

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

Dimensions[data]

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

Improve this question
$\endgroup$
7
  • 1
    $\begingroup$ Please provide an example Excel file that exhibits the problem. $\endgroup$
    – Szabolcs
    Mar 29, 2016 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, 2016 at 0:05
  • 1
    $\begingroup$ @Michael Just upload it to any filehosting like sendspace.com . $\endgroup$
    – Alexey Popkov
    Mar 30, 2016 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, 2016 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, 2016 at 6:13

1 Answer 1

Reset to default
7
$\begingroup$

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"];.

Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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