Re: export data to spreadsheet
- To: mathgroup at smc.vnet.net
- Subject: [mg79320] Re: export data to spreadsheet
- From: Jean-Marc Gulliet <jeanmarc.gulliet at gmail.com>
- Date: Tue, 24 Jul 2007 06:10:54 -0400 (EDT)
- References: <f7v54b$t9b$1@smc.vnet.net><f81n1j$m5j$1@smc.vnet.net>
On Jul 23, 9:57 am, "Steven Shippee" <drou... at comcast.net> wrote:
> How much more involved would it be to get column headings for this output or
> export?
Create a list with your headers and join it as the first row to the
dataset.
data = N[Table[{x, Sin[x], Cos[x], Tan[x]}, {x, 0, 2*Pi, Pi/16}]];
heads = {{"col 1", "col 2", col3, col4}};
Export["test.xls", Join[heads, data], "XLS"];
Regards,
Jean-Marc
> Thanks in advance,
>
> Steven Shippee
> slshippee at comcast.net
>
> "Bob Hanlon" <hanl... at cox.net> wrote in message
>
> news:f7v54b$t9b$1 at smc.vnet.net...
>
> > data = Table[{x, Sin[x], Cos[x], Tan[x]}, {x, 0, 2 Pi, Pi/16}] // N;
>
> > Export["test.xls", data, "XLS"];
>
> > Bob Hanlon
>
> > ---- Martin Channon <mgc... at comcast.net> wrote:
> >> Greetings folks, this is my first time here. I don't use Mathematica
> >> very often, so I don't know the it very well, and I'm stumped on
> >> something that is probably pretty basic. Can anyone tell me how to
> >> export table data to a spreadsheet? Thanks.
- Follow-Ups:
- Re: Re: curve fit for exp function
- From: Martin Channon <mgcqso@comcast.net>
- Re: Re: curve fit for exp function