# HG changeset patch # User artbio # Date 1542891353 18000 # Node ID ddc7b8073704d4b132cca47a0fd79d630428698a # Parent 1c5097aea031db09124a53120df567893fd98739 planemo upload for repository https://github.com/ARTbio/tools-artbio/tree/master/tools/facturation_ibps commit e50a3351cee774b906dac78f95d1c3b374f203aa diff -r 1c5097aea031 -r ddc7b8073704 facturation.py --- 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 diff -r 1c5097aea031 -r ddc7b8073704 facturation.xml --- 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 @@ - + beautifulsoup4 @@ -17,7 +17,7 @@ - +