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

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]]