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

MathGroup Archive 2012

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

Search the Archive

Re: Exporting a formula to Excel via copypaste

  • To: mathgroup at smc.vnet.net
  • Subject: [mg125628] Re: Exporting a formula to Excel via copypaste
  • From: A Retey <awnl at gmx-topmail.de>
  • Date: Fri, 23 Mar 2012 01:31:19 -0500 (EST)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <jkf09d$8kq$1@smc.vnet.net>

Hi,

> I'm trying to copy a fromula from mathematica a and paste it to
> excel. It is a  polynomial. Something like:
>
> -0.00488067+0.000981042 dff+0.000109406 dff^2+1.83066*10^-8
>
> Now, there are two problems: - The exponential is written as 10^-8.
> Which is not compatible with excel. This issue can be solve by using
> ScientificForm. - The second problem: Excel wants asterisks (*) for
> the multiplication. This is solved by doing it this way:
> ScientificForm[rhofit, NumberMultiplier ->  "*"]
>
> Now, the problem is, that NumberMultiplier only adds asterisks where
> you have number, but not if you have variables. Any idea to replace
> the spaces with asterisks?

I would suggest to start from either CForm or FortranForm and adjust the 
details with StringReplace, e.g. the following should work:

StringReplace[
  ToString[FortranForm[-0.00488067 + 0.000981042 dff +
     0.000109406 dff^2 + 1.83066*10^-8 dff^3]],
  {"**" -> "^","dff"->"A1"}
  ]

which will result in:

"-0.00488067 + 0.000981042*A1 + 0.000109406*A1^2 + 1.83066e-8*A1^3"

which I think excel should accept as a formula (at least it did for 
after removing for the double quotes and replacing . with , since I have 
a German version)...

hth,

albert



  • Prev by Date: Re: Exporting a formula to Excel via copypaste
  • Next by Date: Re: Compiling Runge-kutta
  • Previous by thread: Re: Exporting a formula to Excel via copypaste
  • Next by thread: using Mathematica for solving TSP-like problem with route priorities