Mercurial > repos > artbio > facturation_ibps
changeset 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 |
| files | facturation.py facturation.xml |
| diffstat | 2 files changed, 8 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/facturation.py Fri Nov 09 05:59:20 2018 -0500 +++ b/facturation.py Thu Nov 22 07:55:53 2018 -0500 @@ -58,6 +58,10 @@ elements = elements.rename(columns=elements_col).drop( elements.index[0]) + # changement du type des éléments numériques du tableau + elements[u'nombre(s)'] = pd.to_numeric(elements[u'nombre(s)']) + elements[cout_col] = pd.to_numeric(elements[cout_col]) + # ouverture fichier output facture_output = openpyxl.load_workbook( 'template_facture.xlsx', data_only=False, keep_vba=False) @@ -76,11 +80,11 @@ ws.cell( row=element_row, column=2, - value=elements.iloc[i][u'nombre(s)']) + value=elements.iloc[i][u'nombre(s)']).number_format = '0.00' ws.cell( row=element_row, column=4, - value=elements.iloc[i][cout_col]) + value=elements.iloc[i][cout_col]).number_format = '0.00' # ajout de l'adresse address_row = 7
--- a/facturation.xml Fri Nov 09 05:59:20 2018 -0500 +++ b/facturation.xml Thu Nov 22 07:55:53 2018 -0500 @@ -1,4 +1,4 @@ -<tool id="facturation_ibps" name="IBPS facturation parser" version="0.3.2"> +<tool id="facturation_ibps" name="IBPS facturation parser" version="0.3.3"> <description /> <requirements> <requirement type="package" version="4.6.3=py27_0">beautifulsoup4</requirement> @@ -17,7 +17,7 @@ <param format="data" label="Fichier html source" name="input" type="data" /> </inputs> <outputs> - <data format="xlsx" name="output" label="Fichier facturation" /> + <data format="xlsx" name="output" label="Facturation from ${input.name}" /> </outputs> <tests> <test>