Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2008

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

Search the Archive

Re: Export into Excel Worksheets

  • To: mathgroup at smc.vnet.net
  • Subject: [mg90880] Re: Export into Excel Worksheets
  • From: Jean-Marc Gulliet <jeanmarc.gulliet at gmail.com>
  • Date: Mon, 28 Jul 2008 07:51:18 -0400 (EDT)
  • Organization: The Open University, Milton Keynes, UK
  • References: <g6h5f1$h1t$1@smc.vnet.net>

Tugrul Temel wrote:

> Yes, the following code works in exporting data from Mathematica to Excel
> file
> 
> data = RandomReal[{0, 1}, {3, 4, 2}];
> Export["test.xls", data];
> 
> However, in importing the same file "test.xls" back to Mathematica, the
> following code does not work. WHY?
> 
> data1 = Import["D:\test.xls", {"Data", 1}]
> data2 = Import["D:\test.xls", {"Data", 2}]
> data3 = Import["D:\test.xls", {"Data", 3}]

<snip>

It is very likely that you are not reading the file you have just 
created: the exported file "test.xls" is located in $HomeDirectory 
whereas "D:\test.xls" is located on the root level of the second 
drive/partition.


In[1]:= data = RandomReal[{0, 1}, {3, 4, 2}]
Export["test.xls", data]

Out[1]= {{{0.902338, 0.905259}, {0.992485, 0.820032}, {0.324872,
    0.880122}, {0.713961, 0.625327}}, {{0.157472, 0.849435}, {0.947472,
     0.976526}, {0.834299, 0.528255}, {0.994454, 0.807406}}, {{0.61929,
     0.253483}, {0.695069, 0.76067}, {0.635693, 0.0609954}, {0.761752,
    0.608448}}}

Out[2]= "test.xls"

In[3]:= data1 = Import["test.xls", {"Data", 1}]
data2 = Import["test.xls", {"Data", 2}]
data3 = Import["test.xls", {"Data", 3}]

Out[3]= {{0.902338, 0.905259}, {0.992485, 0.820032}, {0.324872,
   0.880122}, {0.713961, 0.625327}}

Out[4]= {{0.157472, 0.849435}, {0.947472, 0.976526}, {0.834299,
   0.528255}, {0.994454, 0.807406}}

Out[5]= {{0.61929, 0.253483}, {0.695069, 0.76067}, {0.635693,
   0.0609954}, {0.761752, 0.608448}}

Regards,
-- Jean-Marc


  • Prev by Date: Re: question about sorting lists
  • Next by Date: Re: Text search within a documentation page?
  • Previous by thread: RE: Re: Export into Excel Worksheets
  • Next by thread: Unprotect[Pi]