Export vers excel

Version imprimable

2 pièce(s) jointe(s)

Export vers excel

Bonjour,
Pour l’export j’ai trouvé une solution qui permet de convertir le fichier « .mm » de freemind vers un fichier « .xls « à partir de l’utilisation de XSLT.

Et après on choisit le fichier freemind/accesoires/mm2xls_utf8.xsl où se trouve l’utilisation de template XSLT pour transformer le fichier .mm en xls

Mais j’ai rencontré un problème au niveau de la conversion des tableaux qui se trouvent dans les commentaires des nœuds vers le fichier excel.

Les tableaux sont enregistrer comme des commentaires dans l’excel et en plus sont pas bien afficher et je veux l’afficher dans les cellules mais je n’ai pas arrivé à le faire.

J’ai essayé de modifier le code de fichier mm2xls_utf8.xsl qui permet de faire l’export est mais pas de résultat.
Avez-vous une idée ( Lignes de codes) pour mettre les commentaires dans des cellules.
Merci à vous.
vous trouvez au dessous le code et des images explicatifs.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
 
<?xml version="1.0" encoding="UTF-8"?>
<!--
    (c) by Naoki Nose, Eric Lavarde 2006-2008
    This code is licensed under the GPLv2 or later.
    (http://www.gnu.org/copyleft/gpl.html)
    Stylesheet to transform a FreeMind map into an Excel sheet, use menu point
    File -> Export -> Using XSLT... to choose this XSL file, and name the
    ExportFile Something.xls or Something.xml.
    2006-12-10: added support for notes and attributes (EWL)
    2008-10-23: corrected issue with ss namespace not being output (EWL)
-->
<xsl:stylesheet version="1.0"
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
 xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:duss="urn:schemas-microsoft-com:office:dummyspreadsheet">
  <xsl:output method="xml" indent="yes" encoding="UTF-8" standalone="yes"/>
  <!-- the duss namespace alias is required in order to be able to output
  ss:Data properly, Excel ignores the extraneous dummy namespace. -->
  <xsl:namespace-alias stylesheet-prefix="duss" result-prefix="ss"/>
 
  <xsl:template match="/map">
    <xsl:processing-instruction name="mso-application"> progid="Excel.Sheet"</xsl:processing-instruction>
    <Workbook>
      <Styles>
 
<Style ss:ID="s16" ss:Name="attribute_cell">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
</Style>
<Style ss:ID="s17" ss:Name="attribute_header">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
</Borders>
<Font ss:Bold="1"/>
</Style>
 
  </Styles>
      <!-- we could probably put something more intelligent as worksheet name,
      but it would require name mangling to avoid unallowed characters -->
      <Worksheet ss:Name="FreeMind Sheet">
        <Table>
<xsl:apply-templates select="node">
<xsl:with-param name="index" select="1" />
</xsl:apply-templates>
        </Table>
      </Worksheet>
    </Workbook>
  </xsl:template>
 
<xsl:template match="node">
<xsl:param name="index" />
<Row><Cell ss:Index="{$index}">
<xsl:call-template name="output-node-text-as-data" />
</Cell>
<xsl:if test="attribute">
<Cell ss:StyleID="s17">
<Data ss:Type="String">Names</Data></Cell>
<Cell ss:StyleID="s17">
<Data ss:Type="String">Values</Data></Cell>
</xsl:if>
</Row>
<xsl:apply-templates select="attribute">
<xsl:with-param name="index" select="$index + 1" />
</xsl:apply-templates>
<xsl:apply-templates select="node">
<xsl:with-param name="index" select="$index + 1" />
</xsl:apply-templates>
</xsl:template>
 
<xsl:template match="attribute">
<xsl:param name="index" />
<Row><Cell ss:Index="{$index}" ss:StyleID="s16">
<Data ss:Type="String"><xsl:value-of select="@NAME" /></Data>
     </Cell>
     <Cell ss:StyleID="s16">
<Data ss:Type="String"><xsl:value-of select="@VALUE" /></Data>
     </Cell>
</Row>
</xsl:template>
 
<xsl:template name="output-node-text-as-data">
<xsl:choose>
<xsl:when test="richcontent[@TYPE='NODE']">
<!-- see comments about rich text and HTML format below -->
<duss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><xsl:copy-of select="richcontent[@TYPE='NODE']/html/body/*" /></duss:Data>
</xsl:when>
<xsl:otherwise>
      <Data ss:Type="String"><xsl:value-of select="@TEXT"/></Data>
<!-- xsl:value-of select="normalize-space(@TEXT)" / -->
</xsl:otherwise>
</xsl:choose>
<xsl:call-template name="output-note-text-as-comment" />
</xsl:template>
 
<!-- export of rich text in HTML format should work, but formatting is lost
because Excel understands only HTML tags in capitals, whereas
FreeMind exports in small caps. This can probably be solved but would
require some more tweaking -->
<xsl:template name="output-note-text-as-comment">
<xsl:if test="richcontent[@TYPE='NOTE']">
<Comment><duss:Data xmlns="http://www.w3.org/TR/REC-html40"><xsl:copy-of
select="richcontent[@TYPE='NOTE']/html/body/*" /></duss:Data></Comment>
</xsl:if>
</xsl:template>
 
</xsl:stylesheet>

06/03/2018, 19h37
tsuji

Si vous pouvez montrer l'échantillon (complet) du document xml en question, on va voir plus clair ceux qui sont le problème et la fonctionnalité recherchée. Le document xslt montré est ce qui est fourni avec le projet, il me semble, sans rien changé : ça aide, mais pas trop pour trouver une solution, si possible.
08/03/2018, 02h07
Dali29

Merci pour votre réponse et voilà le code

<map version="0.9.0">

<node CREATED="1520187478087" ID="ID_585524551" MODIFIED="1520187491168" TEXT="carte exemple">
<node CREATED="1520187493570" ID="ID_574021393" MODIFIED="1520187498987" POSITION="right" TEXT="A">
<node CREATED="1520187513500" ID="ID_1424166960" MODIFIED="1520187893358" TEXT="A1">
<richcontent TYPE="NOTE"><html>
<head>

</head>
<body>
<table border="0" style="width: 80%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Prénom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Nom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Age

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Alex

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

BERNARD

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

38

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Julien

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Suarez

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

25

</td>
</tr>
</table>



<table border="0" style="width: 80%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Prénom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Nom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Age

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Alex

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

BERNARD

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

38

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Julien

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Suarez

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

25

</td>
</tr>
</table>
</body>
</html>
</richcontent>
</node>
<node CREATED="1520187518370" ID="ID_483925278" MODIFIED="1520187893358" TEXT="A2">
<richcontent TYPE="NOTE"><html>
<head>

</head>
<body>
<table border="0" style="width: 80%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Prénom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Nom

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Age

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Alex

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

BERNARD

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

38

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Julien

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Suarez

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

25

</td>
</tr>
</table>
</body>
</html>
</richcontent>
</node>
</node>
<node CREATED="1520187499589" ID="ID_438758500" MODIFIED="1520187501268" POSITION="right" TEXT="B">
<node CREATED="1520187893311" ID="ID_1711714885" MODIFIED="1520188099042" TEXT="B1">
<richcontent TYPE="NOTE"><html>
<head>

</head>
<body>
<table border="0" style="width: 80%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

fonction

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Département

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Unité

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénieur

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénierie

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Qualité

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

technicien

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénierie

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Maintenance

</td>
</tr>
</table>
</body>
</html>
</richcontent>
<node CREATED="1520188108356" ID="ID_717311128" MODIFIED="1520188108356">
<richcontent TYPE="NODE"><html>
<head>

</head>
<body>
<table border="0" style="width: 80%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

onction

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Département

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Unité

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénieur

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénierie

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Qualité

</td>
</tr>
<tr>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

technicien

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Ingénierie

</td>
<td valign="top" style="width: 132%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">

Maintenance

</td>
</tr>
</table>
</body>
</html>
</richcontent>
</node>
</node>
<node CREATED="1520187893311" ID="ID_630506248" MODIFIED="1520187893326" TEXT="B2"/>
<node CREATED="1520187893326" ID="ID_1533259413" MODIFIED="1520187893326" TEXT="B3"/>
</node>
<node CREATED="1520187501764" ID="ID_1809173027" MODIFIED="1520187505608" POSITION="right" TEXT="C"/>
</node>
</map>
08/03/2018, 20h11
tsuji

Merci pour poster le fichier xml (.mm). Je vais regarder de plus près pendant week-end, j'espère.

Juste quelques remarques rapides.
[1] Je pense on devrait charger la version plus à jour 1.0.1; le fichier ne s'applique qu'à la version 0.9.0. Mais en ce qui concerne le rendement recherché, ça reste le même : qu'il n'a toujours pas fourni la solution clé en main, comme vous pouvez remarquez dans les parties commentaires du xslt.
[2] Dans les parties richcontent, on se distingue deux types de fonctionnalité dedans le projets : @TYPE='NODE' et @TYPE='NOTE'. Que voulez-vous faire dans le rendement xlsx pour chacun d'eux ? Ce n'est pas très clair.
12/03/2018, 13h53
Dali29

Merci pour votre réponse,

[1] ce qui concerne la version 1.0.1 c'est la même problème.
Je pense qu'il faut changer la balise <commentaire> par une autre pour permettre l'affichage de tableau sur la feuille excel mais j'ai essayé et j'ai aucune solution résolue.
[2] A propos @TYPE='NODE' et @TYPE='NOTE' la carte c'est en forme des noeuds et à chaque noeud y'a des commentaire TYPE='NODE' c'est le noeud et TYPE='NOTE' c'est le commentaire.

J'ai effectivement regardé un peu tout ça; la sortie en forme de commentaire est par désigne puisque la fonctionnalité n'a pas encore établi, et ils ont dit aussi dans cette partie.

Citation:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<xsl:template name="output-node-text-as-data">
	<xsl:choose>
	<xsl:when test="richcontent[@TYPE='NODE']">
	<!-- see comments about rich text and HTML format below -->
		<duss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><xsl:copy-of select="richcontent[@TYPE='NODE']/html/body/*" /></duss:Data>
	</xsl:when>
	<xsl:otherwise>
	      <Data ss:Type="String"><xsl:value-of select="@TEXT"/></Data>
	<!-- xsl:value-of select="normalize-space(@TEXT)" / -->
	</xsl:otherwise>
	</xsl:choose>
	<xsl:call-template name="output-note-text-as-comment" />
</xsl:template>
 
<!-- export of rich text in HTML format should work, but formatting is lost
	because Excel understands only HTML tags in capitals, whereas
	FreeMind exports in small caps. This can probably be solved but would
	require some more tweaking -->
<xsl:template name="output-note-text-as-comment">
	<xsl:if test="richcontent[@TYPE='NOTE']">
	<Comment><duss:Data xmlns="http://www.w3.org/TR/REC-html40"><xsl:copy-of
			select="richcontent[@TYPE='NOTE']/html/body/*" /></duss:Data></Comment>
	</xsl:if>
</xsl:template>

J'ai fait un prototype pour s'intégrer le tableau dans le workbook: mais j'ai fait tester en isolant la partie node[richcontent/@TYPE='...']. En principe, ça peut s'intégrer en remplaçant la partie xsl:when. Mais dans le xslt original, la partie fait perdre le paramètre $index. J'éssaie de laisser la réinsertion de ce paramètre puisque il joue un rôle dans le positionnement des données. Je n'ai pas modifié cette partie pour la réinsertion, donc, je fais une valeur par défaut au commencement et si vous voulez le compléter, c'est à vous de jouer.

Code:

1
2
3
4
5
6
<xsl:when test="richcontent[@TYPE='NODE']">
    <xsl:apply-templates select="richcontent[@TYPE='NODE'] name="rc-excel">
        <!-- select="3" est seulement un exemple -->
        <xsl:with-param name="index" select="3" />
    </xsl:apply-templates>
</xsl:when>

Et puis, ces templates ajoutés.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<xsl:template match="richcontent[@TYPE='NODE']" name="rc-excel">
    <xsl:param name="index" />
    <Worksheet ss:Name="richcontent">
        <xsl:if test="html/body/table">
            <xsl:call-template name="table">
                <xsl:with-param name="node" select="html/body/table[1]" />
                <xsl:with-param name="tableIndex" select="$index" />
            </xsl:call-template>
        </xsl:if>
    </Worksheet>
</xsl:template>
 
<xsl:template name="table">
    <xsl:param name="node" />
    <xsl:param name="tableIndex" />
    <Table>
        <xsl:attribute name="ss:ExpandedColumnCount">
            <xsl:value-of select="number($tableIndex)+count($node/tr[1]/td)-1" />
        </xsl:attribute>
        <xsl:attribute name="ss:ExpandedRowCount">
            <xsl:value-of select="number($tableIndex)+count($node/tr[1]/td)-1+count($node/tr)-1" />
        </xsl:attribute>
        <xsl:attribute name="x:FullColumns">
            <xsl:value-of select="1" />
        </xsl:attribute>
        <xsl:attribute name="x:FullRows">
            <xsl:value-of select="1" />
        </xsl:attribute>
        <Column>
            <xsl:attribute name="ss:Index">
                <xsl:value-of select="2" />
            </xsl:attribute>
            <xsl:attribute name="ss:AutoFitWidth">
                <xsl:value-of select="0" />
            </xsl:attribute>
            <xsl:attribute name="ss:Width">
                <xsl:value-of select="72"/>
            </xsl:attribute>
        </Column>
        <Row>
            <Cell ss:Index="4"><Data ss:Type="String"> </Data></Cell>
        </Row>
        <xsl:call-template name="tableContent">
            <xsl:with-param name="node" select="$node" />
            <xsl:with-param name="tableIndex" select="$tableIndex" />
        </xsl:call-template>
 
        <!-- allow only one table : to expand -->
    </Table>
</xsl:template>
 
<xsl:template name="tableContent">
    <xsl:param name="node" />
    <xsl:param name="tableIndex" />
 
    <xsl:call-template name="row">
        <xsl:with-param name="node" select="$node/tr[1]" />
        <xsl:with-param name="rowIndex" select="number($tableIndex)+count($node/tr[1]/td)-1" />
        <xsl:with-param name="cellIndex" select="$tableIndex" />
        <xsl:with-param name="indexAttr" select="1" />
    </xsl:call-template>
 
</xsl:template>
 
<xsl:template name="row">
    <xsl:param name="node" />
    <xsl:param name="rowIndex" />
    <xsl:param name="cellIndex" />
    <xsl:param name="indexAttr" />
    <Row>
        <xsl:if test="$indexAttr=1">
            <xsl:attribute name="ss:Index" select="$rowIndex" />
        </xsl:if>
        <xsl:call-template name="cell">
            <xsl:with-param name="node" select="$node/td[1]" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
            <xsl:with-param name="indexAttr" select="1" />
        </xsl:call-template>
    </Row>
    <xsl:if test="$node/following-sibling::tr">
        <xsl:call-template name="row">
            <xsl:with-param name="node" select="$node/following-sibling::tr[1]" />
            <xsl:with-param name="rowIndex" select="$rowIndex+1" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
            <xsl:with-param name="indexAttr" select="0" />
        </xsl:call-template>
    </xsl:if>
</xsl:template>
 
<xsl:template name="cell">
    <xsl:param name="node" />
    <xsl:param name="cellIndex" />
    <xsl:param name="indexAttr" />
    <Cell>
        <xsl:if test="$indexAttr=1">
            <xsl:attribute name="ss:Index" select="$cellIndex" />
        </xsl:if>
        <Data ss:Type="String"><xsl:value-of select="normalize-space($node)" /></Data>
    </Cell>
    <xsl:if test="$node/following-sibling::td">
        <xsl:call-template name="cell">
            <xsl:with-param name="node" select="$node/following-sibling::td[1]" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
        </xsl:call-template>
    </xsl:if>
</xsl:template>

Mais, je n'ai testé que en isolant une instance de richcontent. Quelques attributs pour le formatage devraient dynamiques ? au lieu qu'un tableau 3x3... ça reste à voir. Je n'ai pas toujours assez du temps. Vous pouvez continuer à votre gré. Je reviendrai peut-être ...

16/03/2018, 11h18
Dali29

Merci bien je suis entrain de le regarder et je vais voir que ce qu'il faut ajouter dans ce weekend

Citation:

Envoyé par tsuji

J'ai effectivement regardé un peu tout ça; la sortie en forme de commentaire est par désigne puisque la fonctionnalité n'a pas encore établi, et ils ont dit aussi dans cette partie.

J'ai fait un prototype pour s'intégrer le tableau dans le workbook: mais j'ai fait tester en isolant la partie node[richcontent/@TYPE='...']. En principe, ça peut s'intégrer en remplaçant la partie xsl:when. Mais dans le xslt original, la partie fait perdre le paramètre $index. J'éssaie de laisser la réinsertion de ce paramètre puisque il joue un rôle dans le positionnement des données. Je n'ai pas modifié cette partie pour la réinsertion, donc, je fais une valeur par défaut au commencement et si vous voulez le compléter, c'est à vous de jouer.

Code:

1
2
3
4
5
6
<xsl:when test="richcontent[@TYPE='NODE']">
    <xsl:apply-templates select="richcontent[@TYPE='NODE'] name="rc-excel">
        <!-- select="3" est seulement un exemple -->
        <xsl:with-param name="index" select="3" />
    </xsl:apply-templates>
</xsl:when>

Et puis, ces templates ajoutés.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<xsl:template match="richcontent[@TYPE='NODE']" name="rc-excel">
    <xsl:param name="index" />
    <Worksheet ss:Name="richcontent">
        <xsl:if test="html/body/table">
            <xsl:call-template name="table">
                <xsl:with-param name="node" select="html/body/table[1]" />
                <xsl:with-param name="tableIndex" select="$index" />
            </xsl:call-template>
        </xsl:if>
    </Worksheet>
</xsl:template>
 
<xsl:template name="table">
    <xsl:param name="node" />
    <xsl:param name="tableIndex" />
    <Table>
        <xsl:attribute name="ss:ExpandedColumnCount">
            <xsl:value-of select="number($tableIndex)+count($node/tr[1]/td)-1" />
        </xsl:attribute>
        <xsl:attribute name="ss:ExpandedRowCount">
            <xsl:value-of select="number($tableIndex)+count($node/tr[1]/td)-1+count($node/tr)-1" />
        </xsl:attribute>
        <xsl:attribute name="x:FullColumns">
            <xsl:value-of select="1" />
        </xsl:attribute>
        <xsl:attribute name="x:FullRows">
            <xsl:value-of select="1" />
        </xsl:attribute>
        <Column>
            <xsl:attribute name="ss:Index">
                <xsl:value-of select="2" />
            </xsl:attribute>
            <xsl:attribute name="ss:AutoFitWidth">
                <xsl:value-of select="0" />
            </xsl:attribute>
            <xsl:attribute name="ss:Width">
                <xsl:value-of select="72"/>
            </xsl:attribute>
        </Column>
        <Row>
            <Cell ss:Index="4"><Data ss:Type="String"> </Data></Cell>
        </Row>
        <xsl:call-template name="tableContent">
            <xsl:with-param name="node" select="$node" />
            <xsl:with-param name="tableIndex" select="$tableIndex" />
        </xsl:call-template>
 
        <!-- allow only one table : to expand -->
    </Table>
</xsl:template>
 
<xsl:template name="tableContent">
    <xsl:param name="node" />
    <xsl:param name="tableIndex" />
 
    <xsl:call-template name="row">
        <xsl:with-param name="node" select="$node/tr[1]" />
        <xsl:with-param name="rowIndex" select="number($tableIndex)+count($node/tr[1]/td)-1" />
        <xsl:with-param name="cellIndex" select="$tableIndex" />
        <xsl:with-param name="indexAttr" select="1" />
    </xsl:call-template>
 
</xsl:template>
 
<xsl:template name="row">
    <xsl:param name="node" />
    <xsl:param name="rowIndex" />
    <xsl:param name="cellIndex" />
    <xsl:param name="indexAttr" />
    <Row>
        <xsl:if test="$indexAttr=1">
            <xsl:attribute name="ss:Index" select="$rowIndex" />
        </xsl:if>
        <xsl:call-template name="cell">
            <xsl:with-param name="node" select="$node/td[1]" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
            <xsl:with-param name="indexAttr" select="1" />
        </xsl:call-template>
    </Row>
    <xsl:if test="$node/following-sibling::tr">
        <xsl:call-template name="row">
            <xsl:with-param name="node" select="$node/following-sibling::tr[1]" />
            <xsl:with-param name="rowIndex" select="$rowIndex+1" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
            <xsl:with-param name="indexAttr" select="0" />
        </xsl:call-template>
    </xsl:if>
</xsl:template>
 
<xsl:template name="cell">
    <xsl:param name="node" />
    <xsl:param name="cellIndex" />
    <xsl:param name="indexAttr" />
    <Cell>
        <xsl:if test="$indexAttr=1">
            <xsl:attribute name="ss:Index" select="$cellIndex" />
        </xsl:if>
        <Data ss:Type="String"><xsl:value-of select="normalize-space($node)" /></Data>
    </Cell>
    <xsl:if test="$node/following-sibling::td">
        <xsl:call-template name="cell">
            <xsl:with-param name="node" select="$node/following-sibling::td[1]" />
            <xsl:with-param name="cellIndex" select="$cellIndex" />
        </xsl:call-template>
    </xsl:if>
</xsl:template>

Bonjour tsuji

je reviens vers vous sur l'export en utilisant de l'XSLT j'ai intégré ton code mais y'a toujour une erreur qui s'est affiché

ERREUR XML dans Paramètres de la feuille de cal
RAISON*: Valeur non valide
FICHIER*: C:\Users\user\Desktop\dossier\fichier.xls
GROUPE*: Worksheet
BALISE*: Table
ATTRIB*: ExpandedRowCount
VALEUR*: -1

Je reprends le sujet on-et-off et je arrive une résolution à moi : c'est que les informations supplémentaires présentées comme html sur le noeud richcontent avec l'attribut @TYPE="NODE" devrait se présenter dans un autre Worksheet dedans le même Workbook pour se référencer plus facilement et plus logiquement au lieu d'une tentation de présenter toutes les informations dans un seul et même Worksheet qui est établi dans le xslt document au départ. Ceci simplifie énormément, me semble-t-il, le formatage et aussi plus important à mon sens rendre le Worksheet moins hétérogène d'après la nature des infos et moins lourd. Et puis, le Worksheet supplémentaire est nommé d'après la donnée du cellule et le @ID pour se référer mutuellement plus facilement, le Worksheet maitre et les Worksheet supplémentaires.

Voice le xslt complet remanié pour faire exactement ça avec mes commentaires intercalés avec les originaux.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
<?xml version="1.0" encoding="UTF-8"?>
<!--
    (c) by Naoki Nose, Eric Lavarde 2006-2008
    This code is licensed under the GPLv2 or later.
    (http://www.gnu.org/copyleft/gpl.html)
    Stylesheet to transform a FreeMind map into an Excel sheet, use menu point
    File -> Export -> Using XSLT... to choose this XSL file, and name the
    ExportFile Something.xls or Something.xml.
    2006-12-10: added support for notes and attributes (EWL)
    2008-10-23: corrected issue with ss namespace not being output (EWL)
-->
<xsl:stylesheet version="1.0"
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
 xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:duss="urn:schemas-microsoft-com:office:dummyspreadsheet">
  <xsl:output method="xml" indent="yes" encoding="UTF-8" standalone="yes"/>
 
  <!-- the duss namespace alias is required in order to be able to output
  	ss:Data properly, Excel ignores the extraneous dummy namespace. -->
  <xsl:namespace-alias stylesheet-prefix="duss" result-prefix="ss"/>
 
<xsl:template match="/map">
<xsl:processing-instruction name="mso-application"> progid="Excel.Sheet"</xsl:processing-instruction>
	<Workbook>
		<Styles>
			<Style ss:ID="s16" ss:Name="attribute_cell">
				<Borders>
					<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
				</Borders>
			</Style>
			<Style ss:ID="s17" ss:Name="attribute_header">
				<Borders>
					<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
					<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
				</Borders>
				<Font ss:Bold="1"/>
			</Style>
		</Styles>
		<!-- we could probably put something more intelligent as worksheet name,
      	but it would require name mangling to avoid unallowed characters -->
		<Worksheet ss:Name="FreeMind Sheet">
			<Table>
				<!-- [1] tsuji:note Add a mode to it for clarity. -->
				<xsl:apply-templates select="node" mode="master">	
					<xsl:with-param name="index" select="1" />
				</xsl:apply-templates>
			</Table>
		</Worksheet>
		<!-- [2] tsuji:note Add supplementary treatment to specific kind of node with richcontent. And setup a mode for clarity. -->
		<xsl:apply-templates select=".//node/node[richcontent/@TYPE='NODE']" mode="subtab" />
    </Workbook>
  </xsl:template>
<!-- [3] tsuji:note Add the mode according to evolved design. -->
<xsl:template match="node" mode="master">	
	<xsl:param name="index" />
	<Row><Cell ss:Index="{$index}">
		<xsl:call-template name="output-node-text-as-data" />
	</Cell>
	<xsl:if test="attribute">
		<Cell ss:StyleID="s17">
			<Data ss:Type="String">Names</Data></Cell>
		<Cell ss:StyleID="s17">
			<Data ss:Type="String">Values</Data></Cell>
	</xsl:if>
	</Row>
	<xsl:apply-templates select="attribute">
		<xsl:with-param name="index" select="$index + 1" />
	</xsl:apply-templates>
	<!-- [4] tsuji:note Same as [3]. -->
	<xsl:apply-templates select="node" mode="master">
		<xsl:with-param name="index" select="$index + 1" />
	</xsl:apply-templates>
</xsl:template>
 
<xsl:template match="attribute">
	<xsl:param name="index" />
	<Row><Cell ss:Index="{$index}" ss:StyleID="s16">
		<Data ss:Type="String"><xsl:value-of select="@NAME" /></Data>
	     </Cell>
	     <Cell ss:StyleID="s16">
		<Data ss:Type="String"><xsl:value-of select="@VALUE" /></Data>
	     </Cell>
	</Row>
</xsl:template>
 
<xsl:template name="output-node-text-as-data">
	<xsl:choose>
	<xsl:when test="richcontent[@TYPE='NODE']">
		<!-- see comments about rich text and HTML format below -->
		<!-- [5] tsuji:note Eliminate this for alternative treatment of it. -->
		<!-- duss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><xsl:copy-of select="richcontent[@TYPE='NODE']/html/body/*" /></duss:Data -->		
	</xsl:when>
 
	<xsl:otherwise>
	      <Data ss:Type="String"><xsl:value-of select="@TEXT"/></Data>
		<!-- xsl:value-of select="normalize-space(@TEXT)" / -->
	</xsl:otherwise>
	</xsl:choose>
	<!-- [6] tsuji:note Not quite relevant to excel, it can be suppressed to eliminate seemingly unnecessary noise in the workbook-->
	<!--
	<xsl:call-template name="output-note-text-as-comment" />
	-->
</xsl:template>
 
<!-- export of rich text in HTML format should work, but formatting is lost
	because Excel understands only HTML tags in capitals, whereas
	FreeMind exports in small caps. This can probably be solved but would
	require some more tweaking -->
<xsl:template name="output-note-text-as-comment">
	<xsl:if test="richcontent[@TYPE='NOTE']">
		<Comment>
			<duss:Data xmlns="http://www.w3.org/TR/REC-html40">
				<xsl:copy-of select="richcontent[@TYPE='NOTE']/html/body/*" />
			</duss:Data>
		</Comment>
	</xsl:if>
</xsl:template>
 
<!-- [7] tsuji:note All new content and templates appear below -->
<xsl:template match="node[richcontent/@TYPE='NODE']" mode="subtab">
	<!-- [8] tsuji:note One way to name the worksheet referring both parent's @TEXT and the @ID of itself. -->
	<Worksheet ss:Name="{concat(parent::node/@TEXT, ' - ', @ID)}">
		<xsl:apply-templates select="richcontent[@TYPE='NODE']" mode="subtab" />
	</Worksheet>
 
</xsl:template>
 
<xsl:template match="richcontent[@TYPE='NODE']" mode="subtab">
	<xsl:call-template name="rc-excel" />		
</xsl:template>
 
<xsl:template match="richcontent[@TYPE='NODE']" name="rc-excel">
	<xsl:if test="html/body/table">
		<xsl:call-template name="table">
			<xsl:with-param name="node" select="html/body/table[1]" />
		</xsl:call-template>
	</xsl:if>
</xsl:template>
 
<xsl:template name="table">
	<xsl:param name="node" />
	<Table>
		<!-- [9] tsuji:note Eventually simplified for the moment, data to further ascertain, just a refinement todo.
		<xsl:attribute name="ss:ExpandedColumnCount">
			<xsl:value-of select="count($node/tr[1]/td)" />
		</xsl:attribute>
		<xsl:attribute name="ss:ExpandedRowCount">
			<xsl:value-of select="count($node/tr[1]/td)-1+count($node/tr)" />
		</xsl:attribute>
		<xsl:attribute name="x:FullColumns">
			<xsl:value-of select="1" />
		</xsl:attribute>
		<xsl:attribute name="x:FullRows">
			<xsl:value-of select="1" />
		</xsl:attribute>
		-->
		<xsl:call-template name="tableContent">
			<xsl:with-param name="node" select="$node" />
			<xsl:with-param name="rowIndex" select="1" />
			<xsl:with-param name="cellIndex" select="1" />
		</xsl:call-template>
	</Table>
</xsl:template>
 
<xsl:template name="tableContent">
	<xsl:param name="node" />
	<xsl:param name="rowIndex" />
	<xsl:param name="cellIndex" />
 
	<xsl:call-template name="row">
		<xsl:with-param name="node" select="$node/tr[1]" />
		<xsl:with-param name="rowIndex" select="$rowIndex" />
		<xsl:with-param name="cellIndex" select="$cellIndex" />
	</xsl:call-template>
 
</xsl:template>
 
<xsl:template name="row">
	<xsl:param name="node" />
	<xsl:param name="rowIndex" />
	<xsl:param name="cellIndex" />
	<Row>
		<xsl:attribute name="ss:Index" select="$rowIndex" />
		<xsl:call-template name="cell">
			<xsl:with-param name="node" select="$node/td[1]" />
			<xsl:with-param name="cellIndex" select="$cellIndex" />
		</xsl:call-template>
	</Row>
	<xsl:if test="$node/following-sibling::tr">
		<xsl:call-template name="row">
			<xsl:with-param name="node" select="$node/following-sibling::tr[1]" />
			<xsl:with-param name="rowIndex" select="$rowIndex+1" />
			<xsl:with-param name="cellIndex" select="1" />
		</xsl:call-template>
	</xsl:if>
</xsl:template>
 
<xsl:template name="cell">
	<xsl:param name="node" />
	<xsl:param name="cellIndex" />
	<Cell>
		<xsl:attribute name="ss:Index" select="$cellIndex" />
		<Data ss:Type="String"><xsl:value-of select="normalize-space($node)" /></Data>
	</Cell>
	<xsl:if test="$node/following-sibling::td">
		<xsl:call-template name="cell">
			<xsl:with-param name="node" select="$node/following-sibling::td[1]" />
			<xsl:with-param name="cellIndex" select="$cellIndex+1" />
		</xsl:call-template>
	</xsl:if>
</xsl:template>
 
</xsl:stylesheet>

Essayez-le et il devrait marcher déjà comme tel sans modification de rien.

10/04/2018, 10h08
Dali29

Bonjour Tsuji,

j'ai essayé ton code mais ça marche plus, c'est dommage !
il affiche que les nodes et pas des tableaux!
10/04/2018, 11h45
tsuji

Il y aurait deux worksheet dans le Workbook. Le second worksheet affiche le tableaux @TYPE="NODE".
10/04/2018, 12h06
tsuji

1 pièce(s) jointe(s)

Pièce jointe 368841
10/04/2018, 14h27
Dali29

1 pièce(s) jointe(s)

la deuxième feuille est vide!
Pièce jointe 368891
10/04/2018, 15h00
tsuji

"Exploitation" ? Si vous testez avec un autre mm document, il faut le montrer pour qu'on regarde de quelle spécificité qu'il y ait là, c'est logique, non ? Sinon, on ne sait pas de quoi vous parlez. Pourquoi vous ne testez pas avec le document vous avez montré pour commencer ?

Vous trouvez le code d'un exemple de fichier mm crée par freeplane (c'est la même chose que freemind le fichier xslt est le même)
juste de l'enregistrer avec l'extension .mm parce que j'arrive pas à t'envoyer le fichier.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
<map version="freeplane 1.6.0">
<!--To view this file, download free mind mapping software Freeplane from http://freeplane.sourceforge.net -->
<node TEXT="Carte" FOLDED="false" ID="ID_1982290669" CREATED="1522764682010" MODIFIED="1522765004149" STYLE="oval">
<font SIZE="18"/>
<hook NAME="MapStyle">
    <properties edgeColorConfiguration="#808080ff,#ff0000ff,#0000ffff,#00ff00ff,#ff00ffff,#00ffffff,#7c0000ff,#00007cff,#007c00ff,#7c007cff,#007c7cff,#7c7c00ff" fit_to_viewport="false" show_note_icons="true"/>
 
<map_styles>
<stylenode LOCALIZED_TEXT="styles.root_node" STYLE="oval" UNIFORM_SHAPE="true" VGAP_QUANTITY="24.0 pt">
<font SIZE="24"/>
<stylenode LOCALIZED_TEXT="styles.predefined" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="default" ICON_SIZE="12.0 pt" COLOR="#000000" STYLE="fork">
<font NAME="SansSerif" SIZE="10" BOLD="false" ITALIC="false"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.details"/>
<stylenode LOCALIZED_TEXT="defaultstyle.attributes">
<font SIZE="9"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.note" COLOR="#000000" BACKGROUND_COLOR="#ffffff" TEXT_ALIGN="LEFT"/>
<stylenode LOCALIZED_TEXT="defaultstyle.floating">
<edge STYLE="hide_edge"/>
<cloud COLOR="#f0f0f0" SHAPE="ROUND_RECT"/>
</stylenode>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.user-defined" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="styles.topic" COLOR="#18898b" STYLE="fork">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.subtopic" COLOR="#cc3300" STYLE="fork">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.subsubtopic" COLOR="#669900">
<font NAME="Liberation Sans" SIZE="10" BOLD="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.important">
<icon BUILTIN="yes"/>
</stylenode>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.AutomaticLayout" POSITION="right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="AutomaticLayout.level.root" COLOR="#000000" STYLE="oval" SHAPE_HORIZONTAL_MARGIN="10.0 pt" SHAPE_VERTICAL_MARGIN="10.0 pt">
<font SIZE="18"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,1" COLOR="#0033ff">
<font SIZE="16"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,2" COLOR="#00b439">
<font SIZE="14"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,3" COLOR="#990000">
<font SIZE="12"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,4" COLOR="#111111">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,5"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,6"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,7"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,8"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,9"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,10"/>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,11"/>
</stylenode>
</stylenode>
</map_styles>
</hook>
<hook NAME="AutomaticEdgeColor" COUNTER="3" RULE="ON_BRANCH_CREATION"/>
<node TEXT="a" POSITION="right" ID="ID_1157209752" CREATED="1522764691365" MODIFIED="1522764739815">
<edge COLOR="#ff0000"/>
<node TEXT="AB" ID="ID_419721048" CREATED="1522764692053" MODIFIED="1522764835446"><richcontent TYPE="NOTE">
 
<html>
  <head>
 
  </head>
  <body>
    <table border="0" style="width: 73px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ABN
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            jkllm
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            p^^$$$
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ikkjm
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ljdjhdj jkldmlkd
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ikkokd plk^pk^k^^k^k^k
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            idjioekop
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            opkfeijifjeip^pepkeokop
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ikojijfeljjkljfoijlleff
          </p>
        </td>
      </tr>
    </table>
  </body>
</html>
 
</richcontent>
</node>
<node TEXT="AVVB" FOLDED="true" ID="ID_1396633680" CREATED="1522764726394" MODIFIED="1522764941294"><richcontent TYPE="NOTE">
 
<html>
  <head>
 
  </head>
  <body>
    <table border="0" style="width: 73px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            nkfofo
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kdododod
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            djdjdjdidopp
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kddjdjdj
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            odkdodkdj
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kdjddodddo
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ndnlnlknd
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            knklnldknlkdnldk
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ndlknieniipk,eioj
          </p>
        </td>
      </tr>
    </table>
  </body>
</html>
 
</richcontent>
<node TEXT="AJKL" ID="ID_167193376" CREATED="1522764727588" MODIFIED="1522764766554"/>
</node>
</node>
<node TEXT="C" POSITION="left" ID="ID_889608482" CREATED="1522764706099" MODIFIED="1522764782760">
<edge COLOR="#0000ff"/>
<node TEXT="CJKLD" ID="ID_909977480" CREATED="1522764707412" MODIFIED="1522764991640"><richcontent TYPE="NOTE">
 
<html>
  <head>
 
  </head>
  <body>
    <table border="0" style="width: 73px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-width: 0">
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kjdjk
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            jkdmdmdm
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            mldkmdlkm
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            lmlkmlkmlkdkkm
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kdmlkdml
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kdmlkdmlkdml
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            kdmlk m,mkmlkml
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            dkd kdjdoik
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            iojdijdio dioo iodid
          </p>
        </td>
      </tr>
      <tr>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ididiid didi diididid
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            ididd dididi dididi
          </p>
        </td>
        <td valign="top" style="width: 33%; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-width: 1">
          <p style="margin-top: 1; margin-right: 1; margin-bottom: 1; margin-left: 1">
            dndiddkpod idpokd iodpokd
          </p>
        </td>
      </tr>
    </table>
  </body>
</html>
 
</richcontent>
</node>
</node>
<node TEXT="&#xa8;B" POSITION="right" ID="ID_1886069784" CREATED="1522764713625" MODIFIED="1522764773077">
<edge COLOR="#00ff00"/>
</node>
</node>
</map>

10/04/2018, 18h02
tsuji

Là, il n'y a pas un @TEXT="Exploitation", il n'y a même pas un richcontent @TYPE="NODE". Allez !