Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2012

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Importing xlsx spreadsheet data into Mathematica,

  • To: mathgroup at smc.vnet.net
  • Subject: [mg127749] Re: Importing xlsx spreadsheet data into Mathematica,
  • From: David Bailey <dave at removedbailey.co.uk>
  • Date: Sat, 18 Aug 2012 03:46:24 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • Delivered-to: l-mathgroup@wolfram.com
  • Delivered-to: mathgroup-newout@smc.vnet.net
  • Delivered-to: mathgroup-newsend@smc.vnet.net
  • References: <20120816055857.49B55684D@smc.vnet.net> <k0ksq1$678$1@smc.vnet.net>

On 17/08/2012 08:45, Alan Beilis, Ph.D. wrote:
> Thanks Nigel,
>
> If I understand correctly, you're pointing out that Mathematica,
> Version 8 does this. I understand that. I was wondering if there were
> a workaround using Mathematica,, Version 7 to read an xlsx file (I
> really don't want to have to purchase an upgrade just for this
> problem).
>

XLSX files are often big - their main advantage over XLS files is that 
the size restrictions have been raised. In my experience the import of 
XLSX files with Mathematica 8 is excessively slow.

I ended up decoding the XLSX file (which is actually a ZIP file of a 
bunch of XML files) 'manually' using Java.

David Bailey
http://www.dbaileyconsultancy.co.uk



  • Prev by Date: Re: V8 slow like a snail
  • Next by Date: Defining a total derivative
  • Previous by thread: Re: Importing xlsx spreadsheet data into Mathematica,
  • Next by thread: Re: Importing xlsx spreadsheet data into Mathematica, version 7.0