source: trunk/aeres/scripts/aeresrh.py @ 161

#!/usr/bin/env python
# -*- coding: iso-8859-1 -*-

"""

==========
aeresrh.py
==========

DESCRIPTION
===========

extract information from aeresrh.xls

.. option:: --ifile <file>
              
      file to read

.. only:: man

    Figure is visible on PDF and HTML documents only.

    .. only:: html or latex

       .. graphviz::

             digraph aeresrh {
     rh [shape=diamond,
         fontname=Courier,
 label='{ifile}'

           aeresrh [shape=box,
             fontname=Courier,
               color=blue,
                 URL="http://forge.ipsl.jussieu.fr/pulsation/browser//branches/aeresrh/scripts/aeresrh.py",
           label="${PROJECT}/++/aeresrh.py"];
             }
          
SEE ALSO
========

:ref:

EXAMPLES
========

 aeresrh.py -ifile ${PROJECT}/data/aeresrh.xls

TODO
====

make it work

coding rules (pylint)

EVOLUTIONS
==========

$Id$

$URL$

- fplod 20120405

  * creation draft

"""
    
import sys
import os
from os.path import dirname, basename
import glob
from optparse import OptionParser

try:
    import xlrd
except ImportError:
    print("Failed to import xlrd from any known place")
    sys.exit(1)

def get_option_parser ():
    """parse CLI arguments

           :returns: parser
          :rtype: :class:`optparse.OptionParser`
    """

    parser = OptionParser('%prog [--verbose ] [--ifile file')
    parser.add_option ('-V', '--verbose',
        help='produce verbose output',
        action='store_true',
        default=False,
        dest='is_verbose')
    parser.add_option ('-i', '--ifile',
        help='file to be read',
        type='string',
        dest='ifile',
        default=None,
        action='store')

    return parser

def readrh(ifile, is_verbose):

    """
    read ifile

    return ++
    """
     
    if is_verbose == True:
        print('iii : read %s' % filein_namelist_wrf)

    # ouverture du fichier Excel 
    wb = xlrd.open_workbook(ifile)

    # feuilles dans le classeur
    print wb.sheet_names()

    # lecture des données dans la première feuille
    sh = wb.sheet_by_name(u'Feuil1')
    for rownum in range(sh.nrows):
        print sh.row_values(rownum)

    # lecture par colonne
    colonne1 = sh.col_values(0)
    print colonne1
     
    colonne2=sh.col_values(1)
    print colonne2
    [u'x', 235.0, 245.0, 255.0, 265.0, 275.0, 285.0, 295.0]
  
    # extraction d'un élément particulier
    print colonne1[1],colonne2[1]

    return sh.col_values(1)

def aeresrh():
    """main
        """
    try:
        parser = get_option_parser ()
        (fromcli, args) = parser.parse_args()
    except IOError, msg:
        parser.error(str(msg))

    is_verbose = fromcli.is_verbose
    ifile = fromcli.ifile
    if fromcli.is_verbose == True:
       print ('ifile : %s' % (ifile))

    surname, firstname = readrh(ifile, is_verbose)
    print (' surname %s' % (surname))

# Run main, if called from the command line
if __name__ == '__main__':
    aeresrh()