Changeset 352 for trunk/aeres/scripts/aeresrh.py
- Timestamp:
- 02/19/14 16:16:49 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/aeres/scripts/aeresrh.py
r325 r352 1 1 #!/usr/bin/env python 2 # -*- coding: iso-8859-1-*-2 # -*- coding: utf-8 -*- 3 3 4 4 """ … … 15 15 .. option:: --ifile <file> 16 16 17 17 file to read 18 18 19 19 .. only:: man 20 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 21 Figure is visible on PDF and HTML documents only. 22 23 .. only:: html or latex 24 25 .. graphviz:: 26 27 digraph aeresrh { 28 rh [shape=diamond, 29 fontname=Courier, 30 label='{ifile}' 31 32 aeresrh [shape=box, 33 fontname=Courier, 34 color=blue, 35 URL="http://forge.ipsl.jussieu.fr/pulsation/browser/trunk/aeres/scripts/aeresrh.py", 36 label="${PROJECT}/aeres/scripts/aeresrh.py"]; 37 } 38 38 39 39 SEE ALSO … … 50 50 ======== 51 51 52 :: 53 54 aeresrh.py --ifile ${PROJECT}/data/aeresrh.xls55 56 aeresrh.py --ifile ${HOME}/Downloads/personnel_francoise.xls52 .. code-block:: bash 53 54 aeresrh.py --ifile ${PROJECT}/data/aeresrh.xls 55 56 aeresrh.py --ifile ${HOME}/Downloads/personnel_francoise.xls 57 57 58 58 TODO … … 66 66 67 67 comment j'ai la liste des gens partis au 30 juin 2012 avec 68 publication (retraite, d ecès, mutation)68 publication (retraite, décÚs, mutation) 69 69 70 70 test with real file (encoding, francais, etc) … … 83 83 - fplod 20120426 84 84 85 * big process in diction nary using itertools85 * big process in dictionary using itertools 86 86 87 87 - fplod 20120410 88 88 89 89 * real titles 90 * start diction nary90 * start dictionary 91 91 92 92 - fplod 20120409 … … 101 101 - fplod 20120405 102 102 103 * gestion des temps (arriv ée, départ) (to be cont.)103 * gestion des temps (arrivée, départ) (to be cont.) 104 104 * creation draft 105 105 thanks to http://www.portailsig.org/content/python-lire-et-ecrire-des-fichiers-microsoft-excel-application-quantum-gis … … 181 181 print('sheets name %s' % ( wb.sheet_names())) 182 182 183 # lecture des donn ées dans la première feuille183 # lecture des données dans la premiÚre feuille 184 184 sh = wb.sheet_by_index(0) 185 185 … … 221 221 # detect firstname column 222 222 for colnum in range(sh.ncols): 223 if sh.col_values(colnum)[titlerow] == u'Pr énom':223 if sh.col_values(colnum)[titlerow] == u'Prénom': 224 224 colfirstname = colnum 225 225 if is_verbose == True:
Note: See TracChangeset
for help on using the changeset viewer.