https://beaussier.com/wiki/index.php?action=history&feed=atom&title=Importer_un_fichier_CSV 2026-05-03T20:25:00Z Historique pour cette page sur le wiki MediaWiki 1.27.5 https://beaussier.com/wiki/index.php?title=Importer_un_fichier_CSV&diff=925&oldid=prev 2025-01-08T13:08:59Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='fr'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version du 8 janvier 2025 à 13:08</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10" >Ligne 10 :</td> <td colspan="2" class="diff-lineno">Ligne 10 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; oFiltre = [[zCSV.Demarre]](sFic, &quot;V&quot;)</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; oFiltre = [[zCSV.Demarre]](sFic, &quot;V&quot;)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; [[zCSV.Parametre]](oFiltre, &quot;JEU&quot;, &quot;WIN-1252&quot;)</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; [[zCSV.Parametre]](oFiltre, &quot;JEU&quot;, &quot;WIN-1252&quot;)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160; [[zCSV.Colonne]](oFiltre, 4, &quot;<del class="diffchange diffchange-inline">US</del>&quot;)</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160; [[zCSV.Colonne]](oFiltre, 4, &quot;<ins class="diffchange diffchange-inline">NOMBRE_US</ins>&quot;)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Colonne(oFiltre, 5, &quot;AA/MM/JJ&quot;)</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Colonne(oFiltre, 5, &quot;AA/MM/JJ&quot;)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; </div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; </div></td></tr> </table>

Bidouille https://beaussier.com/wiki/index.php?title=Importer_un_fichier_CSV&diff=435&oldid=prev 2023-12-30T19:03:07Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='fr'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version du 30 décembre 2023 à 19:03</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Ligne 1 :</td> <td colspan="2" class="diff-lineno">Ligne 1 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Importer le fichier CSV suivant dans la feuille &quot;Liste&quot; :</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Importer le fichier CSV suivant dans la feuille &quot;Liste&quot; :</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; id,nom,prenom,valeur,date</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; id,nom,prenom,valeur,date</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160; 1,<del class="diffchange diffchange-inline">Depardieu</del>,<del class="diffchange diffchange-inline">Gérard</del>,100.25,2023-12-01</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160; 1,<ins class="diffchange diffchange-inline">Gabin</ins>,<ins class="diffchange diffchange-inline">Jean</ins>,100.25,2023-12-01</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; 2,Noiret,Philippe,200.50,2023-05-20</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; 2,Noiret,Philippe,200.50,2023-05-20</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Bidouille https://beaussier.com/wiki/index.php?title=Importer_un_fichier_CSV&diff=429&oldid=prev 2023-12-30T18:46:34Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='fr'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Version précédente</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version du 30 décembre 2023 à 18:46</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9" >Ligne 9 :</td> <td colspan="2" class="diff-lineno">Ligne 9 :</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; sFic = &quot;c:\temp\client.csv&quot;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; sFic = &quot;c:\temp\client.csv&quot;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; oFiltre = [[zCSV.Demarre]](sFic, &quot;V&quot;)</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; oFiltre = [[zCSV.Demarre]](sFic, &quot;V&quot;)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Parametre(oFiltre, &quot;JEU&quot;, &quot;WIN-1252&quot;)</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160; <ins class="diffchange diffchange-inline">[[</ins>zCSV.Parametre<ins class="diffchange diffchange-inline">]]</ins>(oFiltre, &quot;JEU&quot;, &quot;WIN-1252&quot;)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Colonne(oFiltre, 4, &quot;US&quot;)</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160; <ins class="diffchange diffchange-inline">[[</ins>zCSV.Colonne<ins class="diffchange diffchange-inline">]]</ins>(oFiltre, 4, &quot;US&quot;)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Colonne(oFiltre, 5, &quot;AA/MM/JJ&quot;)</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; zCSV.Colonne(oFiltre, 5, &quot;AA/MM/JJ&quot;)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; </div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; </div></td></tr> </table>

Bidouille https://beaussier.com/wiki/index.php?title=Importer_un_fichier_CSV&diff=427&oldid=prev 2023-12-30T18:33:22Z

<p>Page créée avec « Importer le fichier CSV suivant dans la feuille &quot;Liste&quot; : id,nom,prenom,valeur,date 1,Depardieu,Gérard,100.25,2023-12-01 2,Noiret,Philippe,200.50,2023-05-20 Sub Main... »</p> <p><b>Nouvelle page</b></p><div>Importer le fichier CSV suivant dans la feuille &quot;Liste&quot; :<br /> id,nom,prenom,valeur,date<br /> 1,Depardieu,Gérard,100.25,2023-12-01<br /> 2,Noiret,Philippe,200.50,2023-05-20<br /> <br /> Sub Main<br /> GlobalScope.BasicLibraries.loadLibrary (&quot;zBasic&quot;)<br /> <br /> sFic = &quot;c:\temp\client.csv&quot;<br /> oFiltre = [[zCSV.Demarre]](sFic, &quot;V&quot;)<br /> zCSV.Parametre(oFiltre, &quot;JEU&quot;, &quot;WIN-1252&quot;)<br /> zCSV.Colonne(oFiltre, 4, &quot;US&quot;)<br /> zCSV.Colonne(oFiltre, 5, &quot;AA/MM/JJ&quot;)<br /> <br /> [[zFeuille.Importe]](sFic, &quot;Liste&quot;, oFiltre) <br /> End Sub<br /> <br /> <br /> [[Category:Exemples]]</div>

Bidouille