Mercurial > repos > artbio > facturation_ibps
comparison facturation.py @ 4:ddc7b8073704 draft
planemo upload for repository https://github.com/ARTbio/tools-artbio/tree/master/tools/facturation_ibps commit e50a3351cee774b906dac78f95d1c3b374f203aa
| author | artbio |
|---|---|
| date | Thu, 22 Nov 2018 07:55:53 -0500 |
| parents | 1c5097aea031 |
| children | 10333ba7d53a |
comparison
equal
deleted
inserted
replaced
| 3:1c5097aea031 | 4:ddc7b8073704 |
|---|---|
| 56 cout_col = elements_col.str.extract(r'(cout.*)', | 56 cout_col = elements_col.str.extract(r'(cout.*)', |
| 57 expand=False).dropna().iloc[0] | 57 expand=False).dropna().iloc[0] |
| 58 elements = elements.rename(columns=elements_col).drop( | 58 elements = elements.rename(columns=elements_col).drop( |
| 59 elements.index[0]) | 59 elements.index[0]) |
| 60 | 60 |
| 61 # changement du type des éléments numériques du tableau | |
| 62 elements[u'nombre(s)'] = pd.to_numeric(elements[u'nombre(s)']) | |
| 63 elements[cout_col] = pd.to_numeric(elements[cout_col]) | |
| 64 | |
| 61 # ouverture fichier output | 65 # ouverture fichier output |
| 62 facture_output = openpyxl.load_workbook( | 66 facture_output = openpyxl.load_workbook( |
| 63 'template_facture.xlsx', data_only=False, keep_vba=False) | 67 'template_facture.xlsx', data_only=False, keep_vba=False) |
| 64 ws = facture_output.worksheets[0] | 68 ws = facture_output.worksheets[0] |
| 65 | 69 |
| 74 element_row += 1 | 78 element_row += 1 |
| 75 ws.cell(row=element_row, column=1, value=elements.iloc[i][u'Objet']) | 79 ws.cell(row=element_row, column=1, value=elements.iloc[i][u'Objet']) |
| 76 ws.cell( | 80 ws.cell( |
| 77 row=element_row, | 81 row=element_row, |
| 78 column=2, | 82 column=2, |
| 79 value=elements.iloc[i][u'nombre(s)']) | 83 value=elements.iloc[i][u'nombre(s)']).number_format = '0.00' |
| 80 ws.cell( | 84 ws.cell( |
| 81 row=element_row, | 85 row=element_row, |
| 82 column=4, | 86 column=4, |
| 83 value=elements.iloc[i][cout_col]) | 87 value=elements.iloc[i][cout_col]).number_format = '0.00' |
| 84 | 88 |
| 85 # ajout de l'adresse | 89 # ajout de l'adresse |
| 86 address_row = 7 | 90 address_row = 7 |
| 87 for i in range(len(adresse)): | 91 for i in range(len(adresse)): |
| 88 address_row += 1 | 92 address_row += 1 |