Mathematica 9 is now available
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, version 7.0

  • To: mathgroup at smc.vnet.net
  • Subject: [mg127739] Re: Importing xlsx spreadsheet data into Mathematica, version 7.0
  • From: Yuri Fadeev <jurasea at yahoo.com>
  • Date: Fri, 17 Aug 2012 03:47:44 -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: <k0i25e$1a9$1@smc.vnet.net>

On Aug 16, 6:58 am, Alan Beilis <abeili... at gmail.com> wrote:
> Has anyone had any luck doing this? If so, would you mind providing
> the Mathematica syntax to do this? Thanks for any and all help!

If your file is located in root directory of C disk and data/results
organized properly then as simple as this:

Import["c:\\test.csv"]
or
Import["c:\\test.xls"][[1]]
or
Import["c:\\test.xlsx"][[1]]



  • Prev by Date: Representing musical timings on a helix
  • Next by Date: Re: Simplify
  • Previous by thread: Re: Importing xlsx spreadsheet data into Mathematica, version 7.0
  • Next by thread: Wolfram Alpha Examples website and cross-site scripting issue