exporting to Excel...

Cottet, Loic (IFPRI) l.cottet at CGIAR.ORG
Mon Jun 19 15:01:33 EDT 2006


 Hi everyone,
 
I have written one script then to export data and make them readable in
Excel.
Hereunder the script:
 
 
'sdfopen data\mrso1.nc'
'set lat 20'
'set lon 55'
'set z 1'
'set t 1 12'
filename='youyou'
'set gxout print'
'd mrso'
rc=write(filename,result)
 
 
The youyou file does not create. It does though when I want the average
(see my attached excel results):
 
 
 
'sdfopen data\mrso1.nc'
'set lat 20 25'
'set lon 52 55'
'set z 1'
'set t 1 12'
'define m1 = ave(mrso.1,t=1,t=601)'
filename='testbis.xls'
'set gxout print'
'd m1'
rc=write(filename,result)
 
 
So, I have 2 questions:
*1st one related to the first script: why can't I have a file created
when I ask to export for each step of time. Indeed, I would like to have
for each grid, a monthly value during my period of time mentionned, do
you know what I mean?
*2nd question: why in Excel the numbers are so big (x*e25, or so small
x*e-17). What are those numbers?
 
 
Thanks a lot for your cooperation,
 
Loic.
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20060619/59379d08/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: testbis.xls
Type: application/vnd.ms-excel
Size: 1838 bytes
Desc: testbis.xls
Url : http://gradsusr.org/pipermail/gradsusr/attachments/20060619/59379d08/attachment.xls 


More information about the gradsusr mailing list