Forum Replies Created

  • Luc

    Member
    5 août 2024 at 18h38 en réponse à: Exploitation de plusieurs fichiers XML

    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é

  • Luc

    Member
    20 mai 2024 at 17h36 en réponse à: Exploitation de plusieurs fichiers XML

    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

  • Luc

    Member
    19 mai 2024 at 7h46 en réponse à: Exploitation de plusieurs fichiers XML

    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

    Member
    18 mai 2024 at 18h24 en réponse à: Exploitation de plusieurs fichiers XML

    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