Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #9204
| 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> |
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
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