Write to spreadsheet headers?

[Pazmush]

Is it possible to put headers above each column in write to spreadsheet? Or at least I need the data to start one line further down...

Any ideas?

[aeastet]

Like this

[Pazmush]

Sorry.... that's no good, i need my numbers to stay as doubles unfortunately.

[falkpl]

Are you trying to write to a spreadsheet file in tab delimited format or dirrectly to a spreadsheet application like excel.

If you are writing to a tdf or cdf then the above will work since all are essentially strings (ascii file), you can change the second %s to %.5f (change the 5 to what ever precision you need in the final file).

[johnsold]

Pazmush,

The spreadsheet will be text or strings.  That is the way the files work.  The code aeastet posted uses doubles - look at the wire color.  The example data all had integer values but was still a double representation.  Look at the help files for the Array to Spreadsheet String function for information about formatting to save as much precision as you need.

Lynn

[falkpl]

Slight modification to allow for precision to be maintained on doubles.  You can also save in minary format or write to excel using a toolkit or activeX but this is more work.

[Pazmush]

ive got numbers that are like 1.34E-14, how do I go about encorporating them? So far i keep getting zeros

[johnsold]

Use the Number to Exponential String function.  It is in the String >> String/Number Conversion palette.

Lynn

[Pazmush]

[Pazmush]

That is what I did