Re: reading excel filesd in NCL

On a related note, we had one person who use the Excel "export"
function to export the file as an ASCII text file with delimiters.
You can then use "str_get_field" to retrieve the columns of interest.

See the "pw.dat" example at:

http://www.ncl.ucar.edu/Applications/read_ascii.shtml

There are other useful examples on this page for dealing with various
kinds of ASCII files.

--Mary

On Nov 29, 2009, at 4:35 PM, Dennis Shea wrote:

> Currently, NCL does not support reading Excel files.
>
> There is a perl script that converts the row/columns to
> csv [comma separated values] text files. Search for
> xls2csv.pl
> This could be invoked
>
> system("xls2csv.pl ...")
>
> Then use (say) asciiread to read the csv file.
>
> ---
> There may be python scrips also.
>
> Good luck
> D
>
>
> Yang Yang wrote:
>> Hello:
>>
>> I have many big excel data files needed to be processed by NCL. I
>> am wondering if a excel file can be read by NCL? How? Any
>> suggestions? Thanks!
>>
>> Ed
> _______________________________________________
> ncl-talk mailing list
> List instructions, subscriber options, unsubscribe:
> http://mailman.ucar.edu/mailman/listinfo/ncl-talk

_______________________________________________
ncl-talk mailing list
List instructions, subscriber options, unsubscribe:
http://mailman.ucar.edu/mailman/listinfo/ncl-talk
Received on Sun Nov 29 20:50:37 2009