Exploitation de plusieurs fichiers XML

  • Exploitation de plusieurs fichiers XML

    Posté par Luc sur 18 mai 2024 à 17h41

    Bonjour

    Pouvez vous m’orienter pour intégrer plusieurs fichiers XML dans Power BI

    Lorsque j’utilise le menu obtenir les données (que ce soit dossier ou XML), je n’obtiens qu’un mouvement par fichier correspondant a priori au nom du fichier et NON son contenu.

    Dans Excel, menu importer des données XML, j’obtiens bien le contenu du fichier soit une colonne par balise (champs) de données.

    Sauriez vous m’orienter pour obtenir dans Power BI le contenu d’un fichier XML (idealement plusieurs combinés si dans le même dossier)

    Merci d’avance

    Luc a répondu Il y a 3 mois, 1 semaine 2 Membres · 7 Réponses
  • 7 Réponses
  • Jonathan

    Membre
    18 mai 2024 à 18h07

    Bonjour Luc,

    Aucun souci pour vous aider. Le plus simple serait de mettre à dispo quelques fichiers à titre d’exemple.

    La technique :

    • Importer un premier fichier avec le connecteur XML,
    • Effectuer toutes les transformations souhaitées dans Power Query pour ce fichier d’exemple,
    • Transformer la requête en fonction,
    • Importer les fichiers via le connecteur Dossier (De préférence Dossier SharePoint pour éviter la gestion des passerelles de données),
    • Appliquer la fonction à l’ensemble des fichiers,
    • Déplier les données,

    Si vous nous fournissez quelques fichiers, je pense qu’on pourra vous montrer un exemple concret dans un fichier pbix.

    A plus tard, bon week-end,

  • Jonathan

    Membre
    18 mai 2024 à 18h18

    Voici un exemple concret avec la récupération de deux fichiers XML (Vous pouvez tester simplement en changeant les sources de données une fois que vous aurez téléchargé les fichiers). J’ai laissé une requête à titre d’exemple puis vous pouvez la comparer avec la fonction Get Tarifs en allant dans l’éditeur avancé. Cela vous donnera une idée des modifications à effectuer.

    Si vous avez des questions, j’y répondrai.

    Bon courage et bon week-end.

  • Luc

    Membre
    18 mai 2024 à 18h24

    Top merci pour votre sollicitude

    Je n’ai plus le temps de tester cet exemple ce soir mais je ne manquerai pas de faire un retour après utilisation.

    Respectueusement

    Bonne soirée

    A bientôt

  • Luc

    Membre
    19 mai 2024 à 7h46

    Bonjour

    J’ai testé l’exemple transmis

    En 1er essai rapide, je n’ai pas réussi à transposer la source avec mon exemple de dossier et fichier XML

    Toutefois celà m’a permis (enfin je crois) de comprendre les principes suivant.

    Je sais déjà qu’un fichier XML est construit selon une hierarchie de données. Donc implicitement une table par niveau hierarchique.

    Dans mon fichier Excel récupérant ces données XML, tous les niveaux (jusqu’au plus bas) ont été déveleppés (par défaut).

    J’ai l’impression que dans Power BI, c’est à moi de préciser quel table je souhaite développer sinon celle ci reste branché sur l’entête du fichier (niveau le plus haut)

    Je vais creuser selon cette hypothèse et reviendrai vers vous au besoin.

  • Luc

    Membre
    20 mai 2024 à 17h36

    Hello

    J’ai tenté de reprendre votre exemple fourni avec mes données sans succès.

    J’ai tenté de reproduire l’exemple fourni de zéro mais je bloque sur la fonction GET xxx et le développement des données

    Puis je compter sur votre aide ?

    Ci-après le fichier XML (prévoir la récupération depuis un dossier et combiner les nouveaux fichiers avec les précédents déjà intégrés dans Power BI)

    FICHIER XML

    La finalité est de récupérer l’ensemble des champs de plusieurs fichiers XML dans une table selon ce modèle que j’avais créé avec EXCEL

    <table style=”border-collapse: collapse; width: 2572pt; height: 61.575px;” border=”0″ width=”3435″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”mso-width-source: userset; mso-width-alt: 10154; width: 214pt;” width=”286″> <col style=”mso-width-source: userset; mso-width-alt: 1166; width: 25pt;” width=”33″> <col style=”mso-width-source: userset; mso-width-alt: 1422; width: 30pt;” width=”40″> <col style=”mso-width-source: userset; mso-width-alt: 8277; width: 175pt;” width=”233″> <col style=”mso-width-source: userset; mso-width-alt: 2730; width: 58pt;” width=”77″> <col style=”mso-width-source: userset; mso-width-alt: 1536; width: 32pt;” width=”43″> <col style=”mso-width-source: userset; mso-width-alt: 3072; width: 65pt;” width=”86″> <col style=”mso-width-source: userset; mso-width-alt: 1422; width: 30pt;” span=”3″ width=”40″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”2″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 1792; width: 38pt;” width=”50″> <col style=”mso-width-source: userset; mso-width-alt: 2730; width: 58pt;” width=”77″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”2″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 2304; width: 49pt;” width=”65″> <col style=”mso-width-source: userset; mso-width-alt: 2730; width: 58pt;” width=”77″> <col style=”mso-width-source: userset; mso-width-alt: 2161; width: 46pt;” width=”61″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”3″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 6257; width: 132pt;” width=”176″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”5″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 6257; width: 132pt;” width=”176″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”4″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 2048; width: 43pt;” width=”58″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”4″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 5518; width: 116pt;” width=”155″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 3072; width: 65pt;” width=”86″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”2″ width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 7281; width: 154pt;” width=”205″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” width=”47″> <col style=”mso-width-source: userset; mso-width-alt: 3868; width: 82pt;” width=”109″> <col style=”mso-width-source: userset; mso-width-alt: 1678; width: 35pt;” span=”2″ width=”47″> </colgroup>
    <tbody>
    <tr style=”height: 20.525px;”>
    <td style=”height: 20.525px; width: 214pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: 0.5pt solid rgb(155, 194, 230); background: rgb(91, 155, 213);” width=”286″ height=”19″>Id</td>
    <td style=”width: 25pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”33″>V</td>
    <td style=”width: 30pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”40″>V2</td>
    <td style=”width: 175pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”233″>V3</td>
    <td style=”width: 58pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”77″>V4</td>
    <td style=”width: 32pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”43″>V5</td>
    <td style=”width: 65pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”86″>V6</td>
    <td style=”width: 30pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”40″>V7</td>
    <td style=”width: 30pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”40″>V8</td>
    <td style=”width: 30pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”40″>V9</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V10</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V11</td>
    <td style=”width: 38pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”50″>V12</td>
    <td style=”width: 58pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”77″>V13</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V14</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V15</td>
    <td style=”width: 49pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”65″>V16</td>
    <td style=”width: 58pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”77″>V17</td>
    <td style=”width: 46pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”61″>V18</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V19</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V20</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V21</td>
    <td style=”width: 132pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”176″>V22</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V23</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V24</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V25</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V26</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V27</td>
    <td style=”width: 132pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”176″>V28</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V29</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V30</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V31</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V32</td>
    <td style=”width: 43pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”58″>V33</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V34</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V35</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V36</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V37</td>
    <td style=”width: 116pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”155″>V38</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V39</td>
    <td style=”width: 65pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”86″>V40</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V41</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V42</td>
    <td style=”width: 154pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”205″>V43</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V44</td>
    <td style=”width: 82pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”109″>V45</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V46</td>
    <td style=”width: 35pt; font-size: 11pt; color: white; font-weight: bold; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: 0.5pt solid rgb(155, 194, 230); border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(91, 155, 213); height: 20.525px;” width=”47″>V47</td>
    </tr>
    <tr style=”height: 20.525px;”>
    <td class=”xl63″ style=”height: 20.525px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: 0.5pt solid rgb(155, 194, 230); background: rgb(221, 235, 247);” height=”19″>PESALR2-06-057103-292-20140107-10244688</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>2</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>ALR</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>ORMC-230103-02042024161425.xml</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>02/04/2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>57113</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>2</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>TES</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>02/04/2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>6</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>8</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>13863,96</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>02/04/2024</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>Factures</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>15</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>Facture FR0000040726 Elec</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>40726</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>5</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>C</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>Facture FR0000040726 Elec</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>PC1</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>588</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1708,91</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>50</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>3</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”> </td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>PARKING X</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>RUE DES LYS</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>57500</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”>SAINT AVOLD</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;” align=”right”>0</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: 0.5pt solid rgb(155, 194, 230); border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; background: rgb(221, 235, 247); height: 20.525px;”> </td>
    </tr>
    <tr style=”height: 20.525px;”>
    <td class=”xl63″ style=”height: 20.525px; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: 0.5pt solid rgb(155, 194, 230);” height=”19″>PESALR2-06-057103-292-20140107-10244688</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>2</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>ALR</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>ORMC-230103-02042024161425.xml</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>02/04/2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>57113</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>2</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>TES</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>02/04/2024</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>6</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>8</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>13863,96</td>
    <td class=”xl64″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>02/04/2024</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>Factures</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>2</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>15</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>Facture FR0000040737 Elec</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>40737</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>P</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>Facture FR0000040737 Elec</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>PC1</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>588</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1005,78</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>50</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>3</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”> </td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>SCI ABC</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”> </td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>1</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>RUE DU LAC</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>57500</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”>SAINT AVOLD</td>
    <td style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: none; border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;” align=”right”>0</td>
    <td class=”xl63″ style=”font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri, sans-serif; border-top: 0.5pt solid rgb(155, 194, 230); border-right: 0.5pt solid rgb(155, 194, 230); border-bottom: 0.5pt solid rgb(155, 194, 230); border-left: none; height: 20.525px;”> </td>
    </tr>
    </tbody>
    </table>

    Merci d’avance

  • Jonathan

    Membre
    21 mai 2024 à 18h06

    Bonjour Luc,

    Cela dépend des fichiers mais oui, en général, c’est à nous de déplier le fichier correctement.

    Je n’arrive pas à récupérer votre fichier 🙁

    A plus tard,

  • Luc

    Membre
    5 août 2024 à 18h38

    Pour information, j e n ai pu que récemment reprendre mon hypothèse de développement.

    J attendais d avoir un ensemble de fichier de même nature”concret” pour pouvoir vérifier le résultat..

    donc c est ok, j ai développé (deux flèches de direction en entête de colonne : ouverture d un menu, laisser l option développer puis ok) sur l ensemble des entêtes proposés (de gauche à droite) jusqu’a affichage des données (une bonne vingtaine de développement successif).

    Le résultat obtenu est celui attendu même avec plusieurs fichiers xml (source dossier).

    Je vais pouvoir croisé ces éléments avec d autres tables selon le besoin.

    je m interroge toutefois si une action simple permettrait de développer TOUT le contenu en une manipulation ?

    bien cordialement

    PS : désolé pour le copier/coller ci dessus qui était lisible à la rédaction du message mais plus lorsqu il fut validé

Connectez-vous pour répondre.