Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #15955
| From | Albert Retey <awnl@gmx-topmail.de> |
|---|---|
| Newsgroups | comp.soft-sys.math.mathematica |
| Subject | Re: Excel XLS Import slowdown in version 8 |
| Date | 2011-02-04 11:58 +0000 |
| Organization | Steven M. Christensen and Associates, Inc and MathTensor, Inc. |
| Message-ID | <iigpkd$212$1@smc.vnet.net> (permalink) |
| References | <iig75v$rkm$1@smc.vnet.net> |
Hi, > I have noticed in Mathematica version 8 that Excel (.xls, not the new > format) importing is about 3.5 times slower than in version 7. I > noticed this because I have a script that reads two sheets from many > Excel files that used to take 1.5 seconds per file that now takes > around 5.18 seconds per file (AbsoluteTiming). Nothing else is done in > that part of the script; it is just a map of an Import command over a > list of Excel files. Is anyone else experiencing this slowdown? What > is the cause? Are there any remedies? We have also noticed that the Import of xls-files can be much slower in Version 8 than it was in Version 7. Especially if there are plots within those files, the import in 8 can be horrible slow, in some cases Import becomes completely useless. It looks like it has to do something with the plots, but so far I have not found a way to avoid that, e.g. by just importing the "Data" element. What has helped in most cases is to delete all plots in the xls-files before importing, but of course that is just a workaround and might not be a solution if you have many files, as seems the case for you... I would be very interested to hear if anyone has found ways to improve the import speed of xls-files in version 8 or switch back to the version 7 behaviour... hth, albert
Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Excel XLS Import slowdown in version 8 Chris Chiasson <chris.chiasson@gmail.com> - 2011-02-04 06:43 +0000
Re: Excel XLS Import slowdown in version 8 fonseca <public@fonseca.info> - 2011-02-08 10:08 +0000
Re: Excel XLS Import slowdown in version 8 Lou <lvveen32@xs4all.nl> - 2011-02-09 07:08 +0000
Re: Excel XLS Import slowdown in version 8 Albert Retey <awnl@gmx-topmail.de> - 2011-02-04 11:58 +0000
Re: Excel XLS Import slowdown in version 8 Lou <lvveen32@xs4all.nl> - 2011-02-08 10:08 +0000
csiph-web