Twitter iPhone pliant OnePlus 11 PS5 Disney+ Orange Livebox Windows 11

Insertion image SVG dans EXCEL

1 réponse
Avatar
frederic89
Bonjour,
Je cherche a inserer dans XL un ficher SVG (image vectorielle).
Le fichier ressemble a :

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!-- Created with Inkscape (http://www.inkscape.org/) -->

<svg
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:cc="http://creativecommons.org/ns#"
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:svg="http://www.w3.org/2000/svg"
xmlns="http://www.w3.org/2000/svg"
version="1.1"
width="210mm"
height="297mm"
id="svg2">
<defs
id="defs4" />
<metadata
id="metadata7">
<rdf:RDF>
<cc:Work
rdf:about="">
<dc:format>image/svg+xml</dc:format>
<dc:type
rdf:resource="http://purl.org/dc/dcmitype/StillImage" />
<dc:title></dc:title>
</cc:Work>
</rdf:RDF>
</metadata>
<g
id="layer1">
<g
transform="matrix(670.40003,0,0,-998.60174,-2958.3076,48075.333)"
id="g3498"
style="fill:#b9b9b9;fill-opacity:1;stroke:#ffffff;stroke-width:0.002;stroke-opacity:1">
<polygon
points="3.69523,47.668 3.72153,47.6767 3.7166,47.6708 3.72399,47.6594 3.71492,47.6325 3.71177,47.6317 3.71177,47.6317 3.70085,47.6393 3.68813,47.6545 3.68695,47.6649 3.67988,47.6701 3.68775,47.676 "
id="89001 ACCOLAY" />
<polygon
points="3.87834,47.7279 3.89294,47.73 3.90979,47.7221 3.9092,47.7117 3.89797,47.7001 3.89797,47.7001 3.88011,47.7091 3.88098,47.7158 3.86227,47.731 3.8674,47.7331 3.87249,47.7336 "
id="89002 AIGREMONT" />
<polygon
points="3.30521,47.8827 3.37711,47.8844 3.37836,47.8833 3.36938,47.8584 3.36938,47.8584 3.33876,47.8604 3.32473,47.8565 3.29387,47.8588 3.27443,47.8693 3.27576,47.8768 "
id="89003 AILLANT-SUR-THOLON" />
<polygon
points="4.19671,47.6749 4.22661,47.6782 4.22573,47.6715 4.2478,47.6588 4.22716,47.6411 4.22365,47.6323 4.21535,47.6308 4.21535,47.6308 4.21048,47.6316 4.20241,47.64 4.17971,47.6468 4.17716,47.6632 4.18422,47.6791 "
id="89004 AISY-SUR-ARMANCON"
style="fill:#ff0000" />
<polygon
points="4.17512,47.8056 4.1837,47.8018 4.19421,47.8085 4.20152,47.8055 4.19253,47.7972 4.20179,47.7816 4.17971,47.7737 4.17321,47.7651 4.1708,47.7517 4.14518,47.7424 4.14293,47.7359 4.14069,47.7349 4.14069,47.7349 4.14856,47.7546 4.12664,47.773 4.12163,47.7768 4.13614,47.779 4.14025,47.7853 "
id="89005 ANCY-LE-FRANC"
style="fill:#ff0000" />
<polygon
points="4.14622,47.8286 4.16409,47.8243 4.18285,47.8254 4.19115,47.8177 4.19421,47.8085 4.1837,47.8018 4.17512,47.8056 4.14025,47.7853 4.13614,47.779 4.12163,47.7768 4.12163,47.7768 4.10554,47.7887 4.11069,47.8066 4.12102,47.8182 4.13411,47.8234 4.13571,47.8298 "
id="89006 ANCY-LE-LIBRE"
style="fill:#ff0000" />
<polygon

Comment inserer cette carte dans excel afin par la suite de colorier les canton en fonction de certaines valeur ( pour cette partie j'ai déja trouvé sur le site)
Merci d'avance,
Cordialement,

1 réponse

Avatar
MichD
Bonjour,

Si tu connais l'adresse exacte du fichier, image :

'----------------------------------------
Sub test()
With ActiveSheet.Pictures
.Insert ("http://www.w3.org/2000/MonImage.jpg")
End With
End Sub
'----------------------------------------