Changeset 162 for trunk/aeres/scripts

Timestamp:

04/05/12 13:51:05 (12 years ago)

Author:

pinsard

Message:

excel demo read ok

File:

• trunk/aeres/scripts/aeresrh.py (modified) (6 diffs)

trunk/aeres/scripts/aeresrh.py

@@ -14 +14 @@
 
 .. option:: --ifile <file>
-              
+
       file to read
 
@@ -36 +36 @@
            label="${PROJECT}/++/aeresrh.py"];
              }
-          
+
 SEE ALSO
 ========
 
-:ref:
+https://secure.simplistix.co.uk/svn/xlrd/trunk/xlrd/doc/xlrd.html
 
 EXAMPLES
@@ -50 +50 @@
 ====
 
-make it work
+test with real file (encoding, francais, etc)
+
+gestion des temps (anne de naissance , arrivée , depard)
+
+remove hard coded number of columns for surname, firstname, ...
 
 coding rules (pylint)
@@ -64 +68 @@
 
   * creation draft
-
+    thanks to http://www.portailsig.org/content/python-lire-et-ecrire-des-fichiers-microsoft-excel-application-quantum-gis
+    and http://scienceoss.com/read-excel-files-from-python/
 """
-    
+
 import sys
 import os
@@ -108 +113 @@
     return ++
     """
-     
-    if is_verbose == True:
-        print('iii : read %s' % filein_namelist_wrf)
-
-    # ouverture du fichier Excel 
+
+    if is_verbose == True:
+        print('iii : read %s' % ifile)
+
+    # ouverture du fichier Excel
     wb = xlrd.open_workbook(ifile)
 
     # feuilles dans le classeur
-    print wb.sheet_names()
+    if is_verbose == True:
+        print('sheets name %s' % ( 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)
+    sh = wb.sheet_by_index(0)
+
+    #
+    if is_verbose == True:
+        for rownum in range(sh.nrows):
+            print('values of in row %d : %s' % (rownum, sh.row_values(rownum)))
+
+    if is_verbose == True:
+        for colnum in range(sh.ncols):
+            print('values of in col %d : %s' % (colnum, sh.col_values(colnum)))
+
+    colsurname = 2
+    colfirstname = 4
+    colarrival = 26
+    coldeparture = 28
+    colpubli = 32 
+
+    surname = sh.col_values(colsurname)
+    # remove the first element because it is the title
+    surname[0] = ''
+    surname = filter(lambda surname: surname != '', surname)
+
+    if is_verbose == True:
+       print(' nb surname %d' % len(surname))
+       print(' surname %s' % surname)
+
+    firstname = []
+    firstname = sh.col_values(colfirstname)
+    # remove the first element because it is the title
+    firstname[0] = ''
+    firstname = filter(lambda firstname: firstname != '', firstname)
+
+    if is_verbose == True:
+       print(' nb firstname %d' % len(firstname))
+       print(' firstname %s' % firstname)
+
+    arrival = []
+    arrival = sh.col_values(colarrival)
+    # remove the first element because it is the title
+    arrival[0] = ''
+    arrival = filter(lambda arrival: arrival != '', arrival)
+
+    if is_verbose == True:
+       print(' nb arrival %d' % len(arrival))
+       print(' arrival %s' % arrival)
+
+    departure = []
+    departure = sh.col_values(coldeparture)
+    # remove the first element because it is the title
+    departure[0] = ''
+    departure = filter(lambda departure: departure != '', departure)
+
+    if is_verbose == True:
+       print(' nb departure %d' % len(departure))
+       print(' departure %s' % departure)
+
+    publi = []
+    publi = sh.col_values(colpubli)
+    # remove the first element because it is the title
+    publi[0] = ''
+    publi = filter(lambda publi: publi != '', publi)
+
+    if is_verbose == True:
+       print(' nb publi %d' % len(publi))
+       print(' publi %s' % publi)
+
+    return surname, firstname, arrival, departure, publi
 
 def aeresrh():
@@ -150 +207 @@
        print ('ifile : %s' % (ifile))
 
-    surname, firstname = readrh(ifile, is_verbose)
+    surname, firstname, arrival, departure,publi = readrh(ifile, is_verbose)
     print (' surname %s' % (surname))