| Re: streaming into Excel? [message #67374] |
Tue, 28 July 2009 20:32 |
cgguido
Messages: 195
Registered: August 2005
|
Senior Member |
|
|
And if you are on a mac, you can follow that with (including the
dollar sign, back-slash and all spaces!):
$open -a Microsoft\ Excel my_summed_file.csv
G
|
|
|
|
| Re: streaming into Excel? [message #67377 is a reply to message #67374] |
Tue, 28 July 2009 13:54  |
David Fanning
Messages: 11724
Registered: August 2001
|
Senior Member |
|
|
Barbara writes:
> ok I've been looking at the code for write_csv, and i don't understand
> how to use it. could you possibly show me an example? I'm trying to
> open a file, master_summed (its a sum of the lines in my master flat).
> How would I enter this into the command line?
I would think like this:
IDL> Write_CSV, 'my_summed_file.csv', master_summed
Cheers,
David
--
David Fanning, Ph.D.
Coyote's Guide to IDL Programming (www.dfanning.com)
Sepore ma de ni thui. ("Perhaps thou speakest truth.")
|
|
|
|
| Re: streaming into Excel? [message #67378 is a reply to message #67377] |
Tue, 28 July 2009 13:39 |
Barbara
Messages: 17
Registered: July 2009
|
Junior Member |
|
|
On Jul 28, 12:04 pm, David Fanning <n...@dfanning.com> wrote:
> Barbara writes:
>> To analyze data, my professor would like me to be able to take data
>> from an array and be able to have it show up in Excel. I know I can
>> print the array to get all the numbers, and can copy and paste it into
>> Excel, but that seems too tedious. Is there a way to stream the
>> information to excel?
>
> If you are using IDL 7.1, you can use WRITE_CSV to
> write a comma separated value file that can be opened
> in Excel.
>
> If you are using a version of IDL earlier than that,
> you can try WRITE_SYLK, which will do something similar.
>
> Cheers,
>
> David
>
> --
> David Fanning, Ph.D.
> Coyote's Guide to IDL Programming (www.dfanning.com)
> Sepore ma de ni thui. ("Perhaps thou speakest truth.")
ok I've been looking at the code for write_csv, and i don't understand
how to use it. could you possibly show me an example? I'm trying to
open a file, master_summed (its a sum of the lines in my master flat).
How would I enter this into the command line?
|
|
|
|
| Re: streaming into Excel? [message #67379 is a reply to message #67378] |
Tue, 28 July 2009 12:04 |
David Fanning
Messages: 11724
Registered: August 2001
|
Senior Member |
|
|
Barbara writes:
> To analyze data, my professor would like me to be able to take data
> from an array and be able to have it show up in Excel. I know I can
> print the array to get all the numbers, and can copy and paste it into
> Excel, but that seems too tedious. Is there a way to stream the
> information to excel?
If you are using IDL 7.1, you can use WRITE_CSV to
write a comma separated value file that can be opened
in Excel.
If you are using a version of IDL earlier than that,
you can try WRITE_SYLK, which will do something similar.
Cheers,
David
--
David Fanning, Ph.D.
Coyote's Guide to IDL Programming (www.dfanning.com)
Sepore ma de ni thui. ("Perhaps thou speakest truth.")
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
