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?

Improve this question
$\endgroup$
2
  • $\begingroup$ But ... how long does it take if you don't time constraint it? $\endgroup$ Commented Feb 24, 2015 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$ Commented Feb 24, 2015 at 1:14

1 Answer 1

Reset to default
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$
5
  • 1
    $\begingroup$ Can you add the issue-tracking number? $\endgroup$ Commented May 28, 2015 at 12:56
  • $\begingroup$ My tracking number is 2558090 $\endgroup$ Commented Jun 2, 2015 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$ Commented Oct 2, 2017 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$ Commented Oct 4, 2017 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$ Commented Oct 4, 2017 at 7:22

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.