6
$\begingroup$

With

SetDirectory["~/Downloads"];
ifile = "test.xls";
TimeConstrained[idata = Import[ifile, {"Data", 1}], 5];

I can achieve the desired result of importing the first page of the spreadsheet in under 5 seconds.

When the same data are reformatted (Excel "Save As ...") to ODS format

SetDirectory["~/Downloads"];
Clear[idata];
ifile = "test.ods";
TimeConstrained[idata = Import[ifile, {"Data", 1}], 60];

times out.

Is ODS Import[] broken? Does anybody else have this issue?

$\endgroup$
  • $\begingroup$ But ... how long does it take if you don't time constraint it? $\endgroup$ – Dr. belisarius Feb 24 '15 at 0:48
  • 2
    $\begingroup$ @belisarius: Good question. I'm cognisant that things take time. However, longer than 10 minutes to read a 500 kb file is stretching the friendship. At 15 minutes, I'm still waiting. $\endgroup$ – dwa Feb 24 '15 at 1:14
4
$\begingroup$

I reported this to Wolfram Research and it has been classiefied as a bug.

No word on a fix.

| improve this answer | |
$\endgroup$
  • 1
    $\begingroup$ Can you add the issue-tracking number? $\endgroup$ – halirutan May 28 '15 at 12:56
  • $\begingroup$ My tracking number is 2558090 $\endgroup$ – dwa Jun 2 '15 at 0:25
  • $\begingroup$ Has this been fixed? I am seeing huge cpu usage with 11.1.0 on LInux without any results, I have to abort in the end. $\endgroup$ – leosenko Oct 2 '17 at 21:46
  • $\begingroup$ @leosenko: I just tried this on 11.2.0. For a very simple data set, I get timings of 0.016, 0.024 & 0.06 for data in xlsx, xls and ods formats respectively suggesting that things may be fixed. How large is your file? $\endgroup$ – dwa Oct 4 '17 at 7:08
  • $\begingroup$ @leosenko: However when I try to Import[RandomReal[{-1, 1}, {64, 64}]], csv, xls, and xlsx are (essentially) instantaneous. ODS times out, so things may not be fixed. $\endgroup$ – dwa Oct 4 '17 at 7:22

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.