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>