VBA Text (.txt) TO XML

**SuperArbre** · 11/07/2013, 17h28

Bonjour à tous,

Je souhaiterais importer un fichier text .txt en VBA dans Excel et lui appliquer une transformation XSL pour obtenir un fichier .XML.

J'utilise déjà le code suivant pour appliquer une transformation XSL à un fichier .XML.

Avez-vous une idée comment: ouvrir un fichier .txt, appliquer une xsl?
Sinon comme deuxième option, je pourrais ouvrir le fichier .txt l'enregistrer en .xml et l'ouvrir une deuxième fois pour appliquer la transformation?

D'avance, merci beaucoup pour votre aide!

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
Public Function transform_XML(sourceFile_path As String, stylesheetFile_path As String) As MSXML2.DOMDocument30
    Dim pSource As MSXML2.DOMDocument30
    Dim pStylesheet As MSXML2.DOMDocument30
    Dim pResult As MSXML2.DOMDocument30
    'set variables
    Set pSource = New MSXML2.DOMDocument30
    Set pStylesheet = New MSXML2.DOMDocument30
    Set pResult = New MSXML2.DOMDocument30
 
    pSource.async = False
    pStylesheet.async = False
    'load XML and XSL
    pSource.Load sourceFile_path
    pStylesheet.Load stylesheetFile_path
 
    If (pSource.parseError.ErrorCode <> 0) Then
       MsgBox ("Error loading source document: " & pSource.parseError.reason)
        Else
        If (pStylesheet.parseError.ErrorCode <> 0) Then
              MsgBox ("Error loading stylesheet document: " & pStylesheet.parseError.reason)
           Else
              ' Do the transform.
              pSource.transformNodeToObject pStylesheet, pResult
        End If
    End If
    Set transform_XML = pResult
End Function

Invité · 12/07/2013, 09h03

bonjour,
as tu un modèle de fichier texte que tu veux convertir en XML?

**SuperArbre** · 12/07/2013, 10h41

Hello,

J'ai travaillé là-dessus toute la nuit

Donc je suis un peu plus avancé que hier. Ma logique est la suivante:
1) transformer un fichier text en XML intermédiaire (enlever les espaces etc.)
2) faire une autre feuille de style pour transformer le fichier xml "correctement"

Donc si je résume, avec VBA je dois changer la variable du fichier XLST intermédiaire (variable "input" contient le nomdufichier.txt) qui enlève les espaces par le fichier importer par l'utilisateur, puis appliquer une feuille de style correcte et enfin enregistrer le document xml dans la base de donnée.

Est-ce que la démarche est correcte? J'essaie de pas me compliquer la vie mais j'ai pas trouvé plus simple?

P.-S. j'ai poster tout le code si ça peut servir à quelqu'un!

Fichier text

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
 
Ugra Proof and Print Certification Tool
Analysis Report
 
Proof Information
 
Date:                   2013-4-4 13:50:53
Report-Version:         v1.5
 
Printing Standard:      ISO Coated v2 (FOGRA39L)
Print Condition:        Offset printing, according to ISO 12647-2:2004/Amd 1, OFCOM, paper type 1 or 2 = coated art, 115 g/m2, tone value increase curves A (CMY) and B (K)
Measurement Condition:  D50, 2 degree, geometry 45/0, no polarisation filter, white backing, according to ISO 13655
 
 
Evaluation Method:      ISO 12647-7 (Proof)
Device:                 eye-one
Measurement Data:       Media Wedge V3
Number of colors:       72
 
 
Job:                    
Printer:                
Paper:                  
Inktype:                
Notes:                  
 
 
Proof - Evaluation Results
 
Category           Delta   Limit  Result
Paper (dE)          9.26    3.00  NOT OK
Average (dE)        7.62    3.00  NOT OK
Maximum (dE)        11.37   6.00  NOT OK
Primaries (dE)      11.37   5.00  NOT OK
Primaries (dH)      3.06    2.50  NOT OK
Average Gray (dH)   1.92    1.50  NOT OK
UGRA-Score                         0.0 %
 
 
 
Measurement Data
 
Name  CMYK                         Reference (L*a*b*)    Measurement (L*a*b*)   dE     dH
A1    100.00   0.00   0.00   0.00   55.00 -37.00 -50.00   63.21 -36.06 -53.99    9.18    3.06
A2     70.00   0.00   0.00   0.00   66.86 -24.73 -37.10   74.17 -23.95 -40.39    8.06    2.41
A3     40.00   0.00   0.00   0.00   79.72 -12.53 -21.75   87.34 -12.71 -24.91    8.25    1.35
A4     20.00   0.00   0.00   0.00   87.68  -5.78 -11.80   95.99  -5.73 -14.77    8.83    1.24
A5     10.00   0.00   0.00   0.00   91.48  -2.97  -6.96  100.07  -2.61  -9.95    9.11    1.30
A6      0.00 100.00   0.00   0.00   48.00  74.00  -3.00   52.18  78.44  -2.81    6.11    0.36
A7      0.00  70.00   0.00   0.00   60.84  50.59  -6.74   67.54  50.51  -6.90    6.70   -0.17
A8      0.00  40.00   0.00   0.00   76.42  25.78  -6.91   83.67  26.90  -8.03    7.42   -0.78
A9      0.00  20.00   0.00   0.00   86.18  12.01  -5.21   93.68  13.90  -7.18    7.98   -0.96
A10     0.00  10.00   0.00   0.00   90.67   5.90  -3.86   98.85   7.57  -6.48    8.75   -1.08
A11     0.00   0.00 100.00   0.00   89.00  -5.00  93.00   97.24  -3.95  95.84    8.78   -1.19
A12     0.00   0.00  70.00   0.00   90.34  -4.70  62.56   98.85  -3.86  64.10    8.69   -0.94
A13     0.00   0.00  40.00   0.00   92.19  -3.47  31.15  100.77  -2.72  34.69    9.31   -1.08
A14     0.00   0.00  20.00   0.00   93.62  -1.62  13.27  102.30  -1.23  13.63    8.70   -0.43
A15     0.00   0.00  10.00   0.00   94.34  -0.94   5.42  103.17  -0.34   4.67    8.88   -0.50
A16     0.00   0.00   0.00  10.00   88.97   0.00  -1.85   97.97   0.87  -4.79    9.51    0.54
A17     0.00   0.00   0.00  20.00   82.79   0.00  -1.69   92.02   0.64  -4.58    9.69    0.39
A18     0.00   0.00   0.00  40.00   69.28   0.00  -1.35   79.14   0.31  -4.04   10.23    0.18
A19     0.00   0.00   0.00  60.00   54.14   0.00  -0.97   64.22  -0.00  -3.24   10.34   -0.00
A20     0.00   0.00   0.00  80.00   36.62   0.00  -0.52   47.87  -0.19  -2.16   11.37   -0.09
A21     0.00   0.00   0.00 100.00   16.00   0.00   0.00   23.30  -0.01   1.34    7.42    0.00
A22     0.00 100.00   0.00 100.00   10.42  13.93   1.35   14.60  19.29   3.16    7.03    1.09
A23     0.00  70.00  70.00  60.00   33.39  25.35  20.88   40.46  25.88  24.11    7.79    2.07
A24     0.00   0.00  70.00  80.00   34.44  -3.27  22.32   44.09  -3.56  26.20   10.40   -0.26
B1    100.00 100.00   0.00   0.00   24.00  22.00 -46.00   28.37  21.14 -46.03    4.45   -0.79
B2     70.00  70.00   0.00   0.00   40.88  17.88 -36.58   47.32  15.39 -36.38    6.90   -2.18
B3     40.00  40.00   0.00   0.00   63.69  10.33 -23.76   70.16  10.60 -24.86    6.57   -0.18
B4     20.00  20.00   0.00   0.00   79.43   5.10 -13.64   86.58   6.49 -15.78    7.59    0.51
B5     10.00  10.00   0.00   0.00   87.17   2.62  -8.14   95.30   3.82 -10.79    8.63    0.28
B6      0.00 100.00 100.00   0.00   47.00  68.00  48.00   51.78  72.84  50.89    7.39   -0.42
B7      0.00  70.00  70.00   0.00   58.50  47.10  37.88   64.69  47.89  41.17    7.06    2.03
B8      0.00  40.00  40.00   0.00   74.18  22.92  21.37   80.77  24.61  24.54    7.50    1.11
B9      0.00  20.00  20.00   0.00   85.00  10.00   9.79   92.18  11.82  10.12    7.41   -0.99
B10     0.00  10.00  10.00   0.00   89.99   4.75   3.71   98.04   6.21   2.85    8.23   -1.49
B11   100.00   0.00 100.00   0.00   50.00 -65.00  27.00   55.87 -64.59  27.20    5.89   -0.34
B12    70.00   0.00  70.00   0.00   62.13 -39.82  21.01   68.26 -39.03  20.19    6.23    0.35
B13    40.00   0.00  40.00   0.00   76.97 -19.06  11.03   84.33 -18.67  13.01    7.63   -1.88
B14    20.00   0.00  20.00   0.00   86.34  -8.38   4.18   94.55  -8.39   4.00    8.22    0.17
B15    10.00   0.00  10.00   0.00   90.79  -4.15   0.89   99.38  -4.00  -0.23    8.67    1.11
B16    10.00   6.00   6.00   0.00   88.54  -0.38  -3.13   96.86   0.21  -4.75    8.49    0.64
B17    20.00  12.00  12.00   0.00   81.95  -0.89  -4.10   89.50  -0.05  -4.69    7.62    0.90
B18    40.00  27.00  27.00   0.00   67.67  -1.96  -4.37   74.19  -0.97  -2.24    6.93    0.05
B19    60.00  45.00  45.00   0.00   52.22  -2.48  -3.53   59.03  -2.87   1.07    8.23   -4.44
B20    80.00  65.00  65.00   0.00   37.47  -3.86  -3.15   44.17  -6.92  -1.12    7.64   -3.06
B21   100.00  85.00  85.00   0.00   26.29  -6.81  -3.41   30.82  -6.66  -0.84    5.21   -2.41
B22   100.00   0.00   0.00 100.00   10.41  -8.20 -10.25   16.78 -11.99 -13.80    8.22   -0.62
B23    20.00 100.00  70.00  60.00   24.28  32.65  13.12   28.19  35.85  15.57    5.62    1.02
B24    70.00   0.00  70.00  80.00   24.67 -17.00   7.51   31.26 -19.34   8.95    7.14   -0.34
C1    100.00 100.00 100.00   0.00   23.00   0.00   0.00   26.86   1.64   2.60    4.94    0.00
C2     70.00  70.00  70.00   0.00   38.53   6.58   3.87   44.40   5.70   5.56    6.17    1.88
C3     40.00  40.00  40.00   0.00   61.53   5.42   3.75   67.47   5.22   5.77    6.28    1.65
C4     20.00  20.00  20.00   0.00   78.14   2.87   0.93   84.95   3.62   0.77    6.85   -0.34
C5     10.00  10.00  10.00   0.00   86.56   1.46  -0.67   94.57   2.16  -1.72    8.11   -0.51
C6     20.00  70.00  70.00   0.00   53.08  37.72  28.91   59.36  36.37  31.99    7.12    3.24
C7     40.00  70.00  70.00  20.00   41.55  22.73  16.76   47.68  20.91  20.50    7.41    4.03
C8     40.00 100.00 100.00  20.00   31.92  39.95  23.98   36.02  42.42  26.96    5.63    1.23
C9     40.00 100.00  40.00  20.00   32.54  44.45  -1.80   36.37  46.32   0.90    5.04    2.72
C10    40.00  40.00 100.00  20.00   51.28   1.27  44.50   57.49   1.01  48.64    7.47    0.37
C11   100.00  40.00 100.00  20.00   34.56 -36.44  13.86   39.15 -36.62  15.08    4.75   -1.07
C12   100.00  40.00  40.00  20.00   35.95 -26.19 -20.86   41.78 -27.74 -19.21    6.25   -2.25
C13   100.00 100.00  40.00  20.00   20.92   9.58 -23.65   24.82   8.49 -21.06    4.81   -0.04
C14    10.00  40.00  40.00   0.00   71.22  18.85  17.25   78.07  19.20  20.47    7.58    2.04
C15     0.00  40.00 100.00   0.00   71.24  22.15  73.08   78.38  23.32  77.41    8.43    0.13
C16     0.00 100.00  40.00   0.00   47.74  71.20  16.24   52.16  75.05  20.09    7.02    2.81
C17    40.00 100.00   0.00   0.00   38.01  55.38 -20.94   42.07  58.14 -21.31    4.92    0.62
C18    40.00   0.00 100.00   0.00   73.66 -22.81  67.57   80.46 -22.12  71.39    7.83   -1.84
C19   100.00   0.00  40.00   0.00   52.33 -52.31 -20.15   59.32 -52.24 -19.22    7.06   -0.85
C20   100.00  40.00   0.00   0.00   43.34 -17.03 -48.62   50.64 -18.10 -50.73    7.68   -0.31
C21     0.00   0.00   0.00   0.00   95.00   0.00  -2.00  103.75   1.09  -4.82    9.26    0.70
C22     0.00   0.00 100.00 100.00   15.71  -3.08  11.68   22.31  -3.87  18.83    9.76   -0.84
C23     0.00  70.00   0.00  60.00   34.69  28.55  -4.01   41.97  28.66  -4.58    7.31   -0.54
C24    70.00   0.00   0.00  80.00   25.84 -11.04 -14.37   34.08 -12.56 -18.13    9.19    0.99

feuille XSLT intermédaire

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
<xsl:stylesheet xmlns:xsl= "http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs" version="2.0">
    <xsl:output method="xml" indent="yes" encoding="utf-8" />    
    <xsl:param name="input" as="xs:string">mesureUPPCT.txt</xsl:param>
 
 
    <xsl:template match="/">         
        <xsl:result-document href = "src1.xml">
            <xsl:copy-of select="$src"/>
        </xsl:result-document>
    </xsl:template>
 
    <!-- this variable contain the full text to put to the xml file at the end -->
    <xsl:variable name="src">
        <doc>
            <!-- break string with regular expression return or new line, for each line process -->
            <xsl:for-each select="tokenize(unparsed-text($input, 'utf-8'), '\r\n')">
                <xsl:call-template name="process_line">
                </xsl:call-template>
            </xsl:for-each>
        </doc>
    </xsl:variable>
 
 
    <xsl:template match="text()" name="process_line">
        <xsl:param name="pString" select="."/>
        <xsl:choose>
        <!-- if the string contains paragraph substring before this symbol -->
         <xsl:when test="contains($pString,'&#xD;')">
             <xsl:variable name="lineBefore" select="substring-before($pString,'&#xD;')"/>
             <xsl:variable name="lineBeforeWithoutSpace" select="normalize-space($lineBefore)"/>
             <!-- if the line isn't empty create new line -->
             <xsl:choose>
                 <xsl:when test="$lineBeforeWithoutSpace != '' ">
                     <line><xsl:value-of select="$lineBeforeWithoutSpace" /></line>
                 </xsl:when>
             </xsl:choose>
             <!-- do this process with the rest of the text -->
             <xsl:variable name="lineAfter" select="substring-after($pString,'&#xD;')"/>
             <xsl:call-template name="process_line">
                 <xsl:with-param name="pString" select="$lineAfter"/>
             </xsl:call-template>
         </xsl:when>
        </xsl:choose>
    </xsl:template>
</xsl:stylesheet>

resultat XML

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
<?xml version="1.0" encoding="utf-8"?>
<doc>
   <line>Ugra Proof and Print Certification Tool</line>
   <line>Analysis Report</line>
   <line>Proof Information</line>
   <line>Date: 2013-4-4 13:50:53</line>
   <line>Report-Version: v1.5</line>
   <line>Printing Standard: ISO Coated v2 (FOGRA39L)</line>
   <line>Print Condition: Offset printing, according to ISO 12647-2:2004/Amd 1, OFCOM, paper type 1 or 2 = coated art, 115 g/m2, tone value increase curves A (CMY) and B (K)</line>
   <line>Measurement Condition: D50, 2 degree, geometry 45/0, no polarisation filter, white backing, according to ISO 13655</line>
   <line>Evaluation Method: ISO 12647-7 (Proof)</line>
   <line>Device: eye-one</line>
   <line>Measurement Data: Media Wedge V3</line>
   <line>Number of colors: 72</line>
   <line>Job:</line>
   <line>Printer:</line>
   <line>Paper:</line>
   <line>Inktype:</line>
   <line>Notes:</line>
   <line>Proof - Evaluation Results</line>
   <line>Category Delta Limit Result</line>
   <line>Paper (dE) 9.26 3.00 NOT OK</line>
   <line>Average (dE) 7.62 3.00 NOT OK</line>
   <line>Maximum (dE) 11.37 6.00 NOT OK</line>
   <line>Primaries (dE) 11.37 5.00 NOT OK</line>
   <line>Primaries (dH) 3.06 2.50 NOT OK</line>
   <line>Average Gray (dH) 1.92 1.50 NOT OK</line>
   <line>UGRA-Score 0.0 %</line>
   <line>Measurement Data</line>
   <line>Name CMYK Reference (L*a*b*) Measurement (L*a*b*) dE dH</line>
   <line>A1 100.00 0.00 0.00 0.00 55.00 -37.00 -50.00 63.21 -36.06 -53.99 9.18 3.06</line>
   <line>A2 70.00 0.00 0.00 0.00 66.86 -24.73 -37.10 74.17 -23.95 -40.39 8.06 2.41</line>
   <line>A3 40.00 0.00 0.00 0.00 79.72 -12.53 -21.75 87.34 -12.71 -24.91 8.25 1.35</line>
   <line>A4 20.00 0.00 0.00 0.00 87.68 -5.78 -11.80 95.99 -5.73 -14.77 8.83 1.24</line>
   <line>A5 10.00 0.00 0.00 0.00 91.48 -2.97 -6.96 100.07 -2.61 -9.95 9.11 1.30</line>
   <line>A6 0.00 100.00 0.00 0.00 48.00 74.00 -3.00 52.18 78.44 -2.81 6.11 0.36</line>
   <line>A7 0.00 70.00 0.00 0.00 60.84 50.59 -6.74 67.54 50.51 -6.90 6.70 -0.17</line>
   <line>A8 0.00 40.00 0.00 0.00 76.42 25.78 -6.91 83.67 26.90 -8.03 7.42 -0.78</line>
   <line>A9 0.00 20.00 0.00 0.00 86.18 12.01 -5.21 93.68 13.90 -7.18 7.98 -0.96</line>
   <line>A10 0.00 10.00 0.00 0.00 90.67 5.90 -3.86 98.85 7.57 -6.48 8.75 -1.08</line>
   <line>A11 0.00 0.00 100.00 0.00 89.00 -5.00 93.00 97.24 -3.95 95.84 8.78 -1.19</line>
   <line>A12 0.00 0.00 70.00 0.00 90.34 -4.70 62.56 98.85 -3.86 64.10 8.69 -0.94</line>
   <line>A13 0.00 0.00 40.00 0.00 92.19 -3.47 31.15 100.77 -2.72 34.69 9.31 -1.08</line>
   <line>A14 0.00 0.00 20.00 0.00 93.62 -1.62 13.27 102.30 -1.23 13.63 8.70 -0.43</line>
   <line>A15 0.00 0.00 10.00 0.00 94.34 -0.94 5.42 103.17 -0.34 4.67 8.88 -0.50</line>
   <line>A16 0.00 0.00 0.00 10.00 88.97 0.00 -1.85 97.97 0.87 -4.79 9.51 0.54</line>
   <line>A17 0.00 0.00 0.00 20.00 82.79 0.00 -1.69 92.02 0.64 -4.58 9.69 0.39</line>
   <line>A18 0.00 0.00 0.00 40.00 69.28 0.00 -1.35 79.14 0.31 -4.04 10.23 0.18</line>
   <line>A19 0.00 0.00 0.00 60.00 54.14 0.00 -0.97 64.22 -0.00 -3.24 10.34 -0.00</line>
   <line>A20 0.00 0.00 0.00 80.00 36.62 0.00 -0.52 47.87 -0.19 -2.16 11.37 -0.09</line>
   <line>A21 0.00 0.00 0.00 100.00 16.00 0.00 0.00 23.30 -0.01 1.34 7.42 0.00</line>
   <line>A22 0.00 100.00 0.00 100.00 10.42 13.93 1.35 14.60 19.29 3.16 7.03 1.09</line>
   <line>A23 0.00 70.00 70.00 60.00 33.39 25.35 20.88 40.46 25.88 24.11 7.79 2.07</line>
   <line>A24 0.00 0.00 70.00 80.00 34.44 -3.27 22.32 44.09 -3.56 26.20 10.40 -0.26</line>
   <line>B1 100.00 100.00 0.00 0.00 24.00 22.00 -46.00 28.37 21.14 -46.03 4.45 -0.79</line>
   <line>B2 70.00 70.00 0.00 0.00 40.88 17.88 -36.58 47.32 15.39 -36.38 6.90 -2.18</line>
   <line>B3 40.00 40.00 0.00 0.00 63.69 10.33 -23.76 70.16 10.60 -24.86 6.57 -0.18</line>
   <line>B4 20.00 20.00 0.00 0.00 79.43 5.10 -13.64 86.58 6.49 -15.78 7.59 0.51</line>
   <line>B5 10.00 10.00 0.00 0.00 87.17 2.62 -8.14 95.30 3.82 -10.79 8.63 0.28</line>
   <line>B6 0.00 100.00 100.00 0.00 47.00 68.00 48.00 51.78 72.84 50.89 7.39 -0.42</line>
   <line>B7 0.00 70.00 70.00 0.00 58.50 47.10 37.88 64.69 47.89 41.17 7.06 2.03</line>
   <line>B8 0.00 40.00 40.00 0.00 74.18 22.92 21.37 80.77 24.61 24.54 7.50 1.11</line>
   <line>B9 0.00 20.00 20.00 0.00 85.00 10.00 9.79 92.18 11.82 10.12 7.41 -0.99</line>
   <line>B10 0.00 10.00 10.00 0.00 89.99 4.75 3.71 98.04 6.21 2.85 8.23 -1.49</line>
   <line>B11 100.00 0.00 100.00 0.00 50.00 -65.00 27.00 55.87 -64.59 27.20 5.89 -0.34</line>
   <line>B12 70.00 0.00 70.00 0.00 62.13 -39.82 21.01 68.26 -39.03 20.19 6.23 0.35</line>
   <line>B13 40.00 0.00 40.00 0.00 76.97 -19.06 11.03 84.33 -18.67 13.01 7.63 -1.88</line>
   <line>B14 20.00 0.00 20.00 0.00 86.34 -8.38 4.18 94.55 -8.39 4.00 8.22 0.17</line>
   <line>B15 10.00 0.00 10.00 0.00 90.79 -4.15 0.89 99.38 -4.00 -0.23 8.67 1.11</line>
   <line>B16 10.00 6.00 6.00 0.00 88.54 -0.38 -3.13 96.86 0.21 -4.75 8.49 0.64</line>
   <line>B17 20.00 12.00 12.00 0.00 81.95 -0.89 -4.10 89.50 -0.05 -4.69 7.62 0.90</line>
   <line>B18 40.00 27.00 27.00 0.00 67.67 -1.96 -4.37 74.19 -0.97 -2.24 6.93 0.05</line>
   <line>B19 60.00 45.00 45.00 0.00 52.22 -2.48 -3.53 59.03 -2.87 1.07 8.23 -4.44</line>
   <line>B20 80.00 65.00 65.00 0.00 37.47 -3.86 -3.15 44.17 -6.92 -1.12 7.64 -3.06</line>
   <line>B21 100.00 85.00 85.00 0.00 26.29 -6.81 -3.41 30.82 -6.66 -0.84 5.21 -2.41</line>
   <line>B22 100.00 0.00 0.00 100.00 10.41 -8.20 -10.25 16.78 -11.99 -13.80 8.22 -0.62</line>
   <line>B23 20.00 100.00 70.00 60.00 24.28 32.65 13.12 28.19 35.85 15.57 5.62 1.02</line>
   <line>B24 70.00 0.00 70.00 80.00 24.67 -17.00 7.51 31.26 -19.34 8.95 7.14 -0.34</line>
   <line>C1 100.00 100.00 100.00 0.00 23.00 0.00 0.00 26.86 1.64 2.60 4.94 0.00</line>
   <line>C2 70.00 70.00 70.00 0.00 38.53 6.58 3.87 44.40 5.70 5.56 6.17 1.88</line>
   <line>C3 40.00 40.00 40.00 0.00 61.53 5.42 3.75 67.47 5.22 5.77 6.28 1.65</line>
   <line>C4 20.00 20.00 20.00 0.00 78.14 2.87 0.93 84.95 3.62 0.77 6.85 -0.34</line>
   <line>C5 10.00 10.00 10.00 0.00 86.56 1.46 -0.67 94.57 2.16 -1.72 8.11 -0.51</line>
   <line>C6 20.00 70.00 70.00 0.00 53.08 37.72 28.91 59.36 36.37 31.99 7.12 3.24</line>
   <line>C7 40.00 70.00 70.00 20.00 41.55 22.73 16.76 47.68 20.91 20.50 7.41 4.03</line>
   <line>C8 40.00 100.00 100.00 20.00 31.92 39.95 23.98 36.02 42.42 26.96 5.63 1.23</line>
   <line>C9 40.00 100.00 40.00 20.00 32.54 44.45 -1.80 36.37 46.32 0.90 5.04 2.72</line>
   <line>C10 40.00 40.00 100.00 20.00 51.28 1.27 44.50 57.49 1.01 48.64 7.47 0.37</line>
   <line>C11 100.00 40.00 100.00 20.00 34.56 -36.44 13.86 39.15 -36.62 15.08 4.75 -1.07</line>
   <line>C12 100.00 40.00 40.00 20.00 35.95 -26.19 -20.86 41.78 -27.74 -19.21 6.25 -2.25</line>
   <line>C13 100.00 100.00 40.00 20.00 20.92 9.58 -23.65 24.82 8.49 -21.06 4.81 -0.04</line>
   <line>C14 10.00 40.00 40.00 0.00 71.22 18.85 17.25 78.07 19.20 20.47 7.58 2.04</line>
   <line>C15 0.00 40.00 100.00 0.00 71.24 22.15 73.08 78.38 23.32 77.41 8.43 0.13</line>
   <line>C16 0.00 100.00 40.00 0.00 47.74 71.20 16.24 52.16 75.05 20.09 7.02 2.81</line>
   <line>C17 40.00 100.00 0.00 0.00 38.01 55.38 -20.94 42.07 58.14 -21.31 4.92 0.62</line>
   <line>C18 40.00 0.00 100.00 0.00 73.66 -22.81 67.57 80.46 -22.12 71.39 7.83 -1.84</line>
   <line>C19 100.00 0.00 40.00 0.00 52.33 -52.31 -20.15 59.32 -52.24 -19.22 7.06 -0.85</line>
   <line>C20 100.00 40.00 0.00 0.00 43.34 -17.03 -48.62 50.64 -18.10 -50.73 7.68 -0.31</line>
   <line>C21 0.00 0.00 0.00 0.00 95.00 0.00 -2.00 103.75 1.09 -4.82 9.26 0.70</line>
   <line>C22 0.00 0.00 100.00 100.00 15.71 -3.08 11.68 22.31 -3.87 18.83 9.76 -0.84</line>
   <line>C23 0.00 70.00 0.00 60.00 34.69 28.55 -4.01 41.97 28.66 -4.58 7.31 -0.54</line>
   <line>C24 70.00 0.00 0.00 80.00 25.84 -11.04 -14.37 34.08 -12.56 -18.13 9.19 0.99</line>
</doc>

VBA Text (.txt) TO XML [XL-2010]

Macros et VBA Excel

Discussions similaires

Partager

Partager