[gradsusr] to write data in a format to open it in Excel 2010?

[Suman Maity]

You can open, edit and other activities of netcdf file through MS-Excell.
All you have to download an add-on for excell and install it. Here I am
sending a link from which you can understand what to do and how:
http://code.google.com/p/netcdf4excel/
Check it and do as written in the link and tell me whether you are
satisfied or not.


Regards
'S Maity'
********************************************************
Suman Maity*
Research Scholar
Center for Ocean, Rivers, Atmosphere and Land Sciences(CORAL)
Indian Institute Of Technology Kharagpur.

******************************************************** *
*  *


On Thu, May 16, 2013 at 8:23 AM, Muhammad Yunus Ahmad Mazuki <
ukm.yunus at gmail.com> wrote:

> I would have prefer to write it in binary, and open it with Scilab or
> Matlab. Especially when you need to do repetitious works like simple
> transformation and plotting, and you have lots of files to read and plots
> to make. You can easily use Scilab to make it autonomous. Excel is a
> powerfull if you use the macro, but to me Scilab is easier.
>
>
> On Thu, May 16, 2013 at 1:51 AM, James E. Johnson <James.Johnson at nasa.gov>wrote:
>
>> On Wednesday 15 May 2013 09:41:48 am Gürol Çerçi wrote:
>> > Hello everyone,
>> >
>> > I have gridded data in netcdf format. I can open the data in Grads and
>> do
>> >  the analyses, but I want to save the result data in a format that I can
>> >  open that data in Excel 2010.
>> >
>> > I could manage to save the data in netcdf format, but Excel can not open
>> >  that.
>> >
>> > How can I write output data in a format (like .dat or ascii) that Excel
>> can
>> >  open that file?
>> >
>> > Thanks...
>> >
>>
>> There is no such thing as an ASCII file format, ASCII is a character
>> encoding
>> scheme for writing text using 128 binary values from 0x00 (0) to 0x7f
>> (127),
>> 32 of these are non-printing control characters that are obsolete today. A
>> file can be in a format that uses ASCII characters, but there isn't a
>> universal ASCII file format.
>>
>> What you want is to create a file that uses a ASCII characters in a comma
>> separated value (CSV) format. You have to write each row and column of
>> your
>> array separated by a delimiter either comma, space or tab. Then import
>> into
>> Excel as a CSV file, and specify the delimiter (comma, space or tab).
>>
>>
>> ------------------------------------------------------------------------------
>> | James E. Johnson                   | address:
>>    |
>> | ADNET Systems, Inc.                |  NASA Goddard Space Flight Center
>>     |
>> | e-mail: james.johnson at nasa.gov     |  Data and Information Services
>> Center |
>> | phone:  301-614-5121               |  Code 610.2, Bldg 32, Room S130G
>>      |
>> | fax:    301-614-5268               |  Greenbelt, MD  20771
>>     |
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> gradsusr mailing list
>> gradsusr at gradsusr.org
>> http://gradsusr.org/mailman/listinfo/gradsusr
>>
>
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20130516/36075dbe/attachment-0003.html