Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #9204

Re: Exporting a formula to Excel via copypaste

From A Retey <awnl@gmx-topmail.de>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Exporting a formula to Excel via copypaste
Date 2012-03-23 06:31 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <jkh5cp$jr7$1@smc.vnet.net> (permalink)
References <jkf09d$8kq$1@smc.vnet.net>

Show all headers | View raw


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

Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Exporting a formula to Excel via copypaste ruesche83@gmail.com - 2012-03-22 10:52 +0000
  Re: Exporting a formula to Excel via copypaste A Retey <awnl@gmx-topmail.de> - 2012-03-23 06:31 +0000

csiph-web