Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #11370 > unrolled thread

Importing xlsx spreadsheet data into Mathematica, version 7.0

Started byAlan Beilis <abeilis99@gmail.com>
First post2012-08-16 05:58 +0000
Last post2012-08-17 07:45 +0000
Articles 3 — 3 participants

Back to article view | Back to comp.soft-sys.math.mathematica


Contents

  Importing xlsx spreadsheet data into Mathematica, version 7.0 Alan Beilis <abeilis99@gmail.com> - 2012-08-16 05:58 +0000
    Re: Importing xlsx spreadsheet data into Mathematica, version 7.0 Helen Read <readhpr@gmail.com> - 2012-08-17 07:45 +0000
    Re: Importing xlsx spreadsheet data into Mathematica, version 7.0 Yuri Fadeev <jurasea@yahoo.com> - 2012-08-17 07:45 +0000

#11370 — Importing xlsx spreadsheet data into Mathematica, version 7.0

FromAlan Beilis <abeilis99@gmail.com>
Date2012-08-16 05:58 +0000
SubjectImporting xlsx spreadsheet data into Mathematica, version 7.0
Message-ID<k0i25e$1a9$1@smc.vnet.net>
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!

[toc] | [next] | [standalone]


#11391

FromHelen Read <readhpr@gmail.com>
Date2012-08-17 07:45 +0000
Message-ID<k0ksqm$67h$1@smc.vnet.net>
In reply to#11370
On 8/16/2012 1:58 AM, Alan Beilis 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!
>

I don't remember when Mathematica first began supporting Import and 
Export of .xlsx, but if might not have been until version 8. So try 
saving your spreadsheet as .xls and import that.

Even in version 8, I find that importing and exporting .xls often works 
better than .xlsx.

--
Helen Read
University of Vermont

[toc] | [prev] | [next] | [standalone]


#11394

FromYuri Fadeev <jurasea@yahoo.com>
Date2012-08-17 07:45 +0000
Message-ID<k0ksrl$67t$1@smc.vnet.net>
In reply to#11370
On Aug 16, 6:58 am, Alan Beilis <abeili...@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]]

[toc] | [prev] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web