Re: Version 6 won't import Excel (Mac)
- To: mathgroup at smc.vnet.net
- Subject: [mg81603] Re: [mg81576] Version 6 won't import Excel (Mac)
- From: Syd Geraghty <sydgeraghty at mac.com>
- Date: Sat, 29 Sep 2007 02:25:01 -0400 (EDT)
- References: <200709280610.CAA27044@smc.vnet.net>
Murray,
I do not reproduce your problem on my MAC.
Import["/Users/sydgeraghty/Desktop/noisydata.xls"]
{{{0., 0.119618}, {0.1, 0.099866}, {0.2, 0.577155}, {0.3, 0.635008},
{0.4,
0.911217}, {0.5, 0.923602}, {0.6, 1.07987}, {0.7, 1.10321}, {0.8,
0.843141}, {0.9, 0.945008}, {1., 0.749222}, {1.1,
0.605487},....Data Good
Import["/Users/sydgeraghty/Desktop/noisydatacsv.csv"]
{{0, 0.119618}, {0.1, 0.099866}, {0.2, 0.577155}, {0.3, 0.635008}, {0.4,
0.911217}, {0.5, 0.923602}, {0.6, 1.07987}, {0.7, 1.10321}, {0.8,
0.843141}, {0.9, 0.945008}, {1, 0.749222}, {1.1,
0.605487},......Data Good
However I also tried my newly released iWork Numbers08. I dragged the
Excel file to
Numbers08 and the Numbers application opened with the data OK. After
I saved the file
I then tried to import it into Mathematica with the following result.
Import["/Users/sydgeraghty/Desktop/noisydataNumbers08.numbers"]
{"Contents/PkgInfo", "document-thumbnail.tiff", "index.xml.gz", \
"QuickLook/Thumbnail.jpg"}
I will look into this as time permits.
Hope this helps
Syd Geraghty
My System
$Version 6.0 for Mac OS X x86 (32 - bit) (June 19, 2007)
$OperatingSystem MacOS X V 10.4 .10
2.33 Ghz Intel Core 2 Duo
On Sep 27, 2007, at 11:10 PM, Murray Eisenberg wrote:
> A colleague who uses a Mac with MacOS 10.4.10 has the following
> Mathematica 6 problem: He cannot get Import to work with either
> an .xls
> file or a .csv file created from an Excel spreadsheet.
>
> Instead, the resulting Output cell just contains a button that says
> "Import" followed by the arguments used to call Import in square
> brackets. Clicking the button just opens the Documentation Center
> window to the page for "ref/Import" which describes how to use the
> function.
>
> Has anyone else experienced this on Macs? Does Mathematica 6 possibly
> use Java, and could there be some configuration problem involving
> that?
> --
>
> Murray Eisenberg murray at math.umass.edu
> Mathematics & Statistics Dept.
> Lederle Graduate Research Tower phone 413 549-1020 (H)
> University of Massachusetts 413 545-2859 (W)
> 710 North Pleasant Street fax 413 545-1801
> Amherst, MA 01003-9305
>
- References:
- Version 6 won't import Excel (Mac)
- From: Murray Eisenberg <murray@math.umass.edu>
- Version 6 won't import Excel (Mac)