comp.lang.idl-pvwave archive: archive

Home » Public Forums » archive » Re: exporting data

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: exporting data [message #20470]

Wed, 21 June 2000 00:00

Liam E. Gumley
Messages: 378
Registered: January 2000

Senior Member

Brad Gom wrote:
> If you specifically want to write a file for use in Excel, then its best to
> write a text file where the values are seperated with commas (a CSV file). You
> can use the PRINTF procedure to write formated text to a file, or WRITEU to
> write binary data.
>
> for example:
>
> data=findgen(10,5)
> ;Open LUN 1 for data.csv with write access.
> OPENW, 1, 'data.csv'
> ;Do the output operation to the file.
> PRINTF, 1, data,format='(9(f,","),f)'
> ;Close the file.
> CLOSE, 1
>
> This will print out the contents of the data array, seperated with commas. Look
> at the FORMAT keyword in the help to see how it works.
>
> Brad

You could try the WRITE_SYLK function, which writes a SYLK format file:

IDL> a = dist(256)
IDL> result = write_sylk('test.sylk', a)

Excel97 apparently reads this format, but I have not tried it.

Cheers,
Liam.
http://cimss.ssec.wisc.edu/~gumley

Report message to a moderator

[Message index]

		Re: exporting data By: Liam E. Gumley on Wed, 21 June 2000 00:00
		Re: exporting data By: Brad Gom on Wed, 21 June 2000 00:00
		Re: exporting data By: Brad Gom on Wed, 21 June 2000 00:00

Previous Topic:	Re: Creating a GIF file from a graphics window in IDL
Next Topic:	exporting data

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 02 01:29:37 PST 2025

Total time taken to generate the page: 2.71935 seconds