Exploitation de plusieurs fichiers XML
-
Exploitation de plusieurs fichiers XML
Posté par Luc sur 18 mai 2024 à 17h41Bonjour
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
-
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,
-
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.
-
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
-
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.
-
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)
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
-
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,
-
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.