Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #11370 > unrolled thread
| Started by | Alan Beilis <abeilis99@gmail.com> |
|---|---|
| First post | 2012-08-16 05:58 +0000 |
| Last post | 2012-08-17 07:45 +0000 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.soft-sys.math.mathematica
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
| From | Alan Beilis <abeilis99@gmail.com> |
|---|---|
| Date | 2012-08-16 05:58 +0000 |
| Subject | Importing 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]
| From | Helen Read <readhpr@gmail.com> |
|---|---|
| Date | 2012-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]
| From | Yuri Fadeev <jurasea@yahoo.com> |
|---|---|
| Date | 2012-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