MathGroup Archive 2007

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

Search the Archive

Re: Data Export to Excel, Reals or now Strings?

  • To: mathgroup at smc.vnet.net
  • Subject: [mg78282] Re: Data Export to Excel, Reals or now Strings?
  • From: Bill Rowe <readnewsciv at sbcglobal.net>
  • Date: Wed, 27 Jun 2007 05:35:21 -0400 (EDT)

On 6/26/07 at 4:34 AM, kristophs.post at web.de (kristoph) wrote:

>I exported simulated data to manipulate it in excel. The problem
>that I have is that sometimes not always a data point  is exported
>to excel like the following:
>00000000000000000000000000000000000000000000000000000000000000000000
>0000000000000000000000000000
>00000000000000000000000000000000000000000000000000000000000000000000
>0000000000000000000000000000
>00000000000000000000000000000000000000000000000000000000000000000000
>0000000000000000000000000000
>00000000000000000000000000000000000000000000000000000000000010923543
>112535720334421513 (this is suppose to be one number)

>instead of 1.09235431125357203344215132`15.954589770191042*^-349
>which is the result calculated by Mathematica 5.2.

>I would like to import the data back to Mathematica after the
>manipulations which result in errors during calculations since some
>of the data point, like the one above are now stings and not reals.

I am fairly certain the issue here is the number being exported
is not something that can be represented as a machine number on
your system. On my system:

In[3]:= {$MinMachineNumber, $MaxMachineNumber}

Out[3]= {2.2250738585072014*^-308, 1.7976931348623157*^308}

anything outside of this range cannot be represented by a
machine number. Consequently, Mathematica has no simple and
obvious way to do what you appear to want.
--
To reply via email subtract one hundred and four


  • Prev by Date: Re: Re: search for an operator in an expression
  • Next by Date: Re: PlotLegend and ListPlot
  • Previous by thread: Data Export to Excel, Reals or now Strings?
  • Next by thread: Re: Data Export to Excel, Reals or now Strings?