MathGroup Archive 2007

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

Search the Archive

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
>



  • Prev by Date: Re: bug in sort?
  • Next by Date: Re: CompleteCharacters Palette in v6?
  • Previous by thread: Version 6 won't import Excel (Mac)
  • Next by thread: Re: Version 6 won't import Excel (Mac)