{"id":11900,"date":"2026-01-06T16:41:24","date_gmt":"2026-01-06T21:41:24","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=11900"},"modified":"2026-01-06T16:41:25","modified_gmt":"2026-01-06T21:41:25","slug":"did-you-know-powershell-can-create-visio-diagrams","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=11900","title":{"rendered":"Did you know … Powershell can create Visio diagrams!?!"},"content":{"rendered":"\n

I had to create a number of Visio diagrams for a new project. Since Blender has a Python API, I wondered if I could do something similar with Visio. There does appear to be an VSDX library for Python<\/a>, I also found that Powershell can just control the Visio instance on my laptop. <\/p>\n\n\n\n

This is a demo creating a diagram for a simple web server with a database back end. You can, however, use any stencils and make more complicated diagrams. The lines aren’t great — part of my Visio diagramming process is moving things around to optimize placement to avoid overlapping and confusing lines. The programmatic approach doesn’t do that, but it gets everything in the diagram. You can then move them as needed. <\/p>\n\n\n

\n# Sample Visio diagram: Firewall -> Load Balancer -> Web Servers -> Database\n# Auto-discovers stencils\n# Works on Windows PowerShell 5.x\n\n$ErrorActionPreference = "Stop"\n\n# Output\n$docName = "WebApp-LB-Firewall-DB.vsdx"\n$outPath = Join-Path $HOME "Documents\\$docName"\n\n# Start Visio\n$visio = New-Object -ComObject Visio.Application\n$visio.Visible = $true\n\n# New document\/page\n$doc = $visio.Documents.Add("")\n$page = $visio.ActivePage\n$page.Name = "Architecture"\n$page.PageSheet.CellsU("PageWidth").ResultIU  = 22.0\n$page.PageSheet.CellsU("PageHeight").ResultIU = 14.0\n\n# -------------------------------\n# Stencil discovery and loading\n# -------------------------------\n\n$searchRoots = @(\n    "$env:PROGRAMFILES\\Microsoft Office\\root\\Office16\\Visio Content",\n    "$env:PROGRAMFILES\\Microsoft Office\\root\\Office16\\Visio Content\\1033",\n    "$env:ProgramFiles(x86)\\Microsoft Office\\root\\Office16\\Visio Content",\n    "$env:ProgramFiles(x86)\\Microsoft Office\\root\\Office16\\Visio Content\\1033",\n    "$env:PROGRAMFILES\\Microsoft Office\\root\\Office15\\Visio Content",\n    "$env:ProgramFiles(x86)\\Microsoft Office\\root\\Office15\\Visio Content",\n    "$env:PROGRAMFILES\\Microsoft",\n    "$env:ProgramFiles(x86)\\Microsoft",\n    "$env:PROGRAMFILES",\n    "$env:ProgramFiles(x86)"\n) | Where-Object { Test-Path $_ }\n\n# Keywords to select useful stencils (filename match, case-insensitive)\n$stencilKeywords = @("network","server","compute","computer","azure","cloud","firewall","security","database","sql","load","balancer","web","iis")\n\nfunction Find-StencilFiles {\n    param([string[]]$roots, [string[]]$keywords)\n    $results = @()\n    foreach ($root in $roots) {\n        try {\n            Get-ChildItem -Path $root -Filter *.vssx -Recurse -ErrorAction SilentlyContinue | ForEach-Object {\n                $fname = $_.Name.ToLower()\n                foreach ($kw in $keywords) {\n                    if ($fname -match $kw) { $results += $_.FullName; break }\n                }\n            }\n        } catch { }\n    }\n    $results | Select-Object -Unique\n}\n\nfunction Load-Stencils {\n    param([string[]]$files)\n    $loaded = @()\n    foreach ($file in $files) {\n        try {\n            Write-Host "Loading stencil: $file"\n            $loaded += $visio.Documents.OpenEx($file, 64) # read-only\n        } catch {\n            Write-Warning "Could not load stencil: $file"\n        }\n    }\n    foreach ($docX in $visio.Documents) {\n        if ($docX.FullName -ne $doc.FullName) { $loaded += $docX }\n    }\n    $loaded | Sort-Object FullName -Unique\n}\n\n$files = Find-StencilFiles -roots $searchRoots -keywords $stencilKeywords\n$stencils = Load-Stencils -files $files\n\nif (!$stencils -or $stencils.Count -eq 0) {\n    Write-Warning "No stencil files loaded automatically. Fallback rectangles will be used."\n} else {\n    Write-Host "`nLoaded stencils:" -ForegroundColor Cyan\n    foreach ($s in $stencils) { Write-Host " - $($s.FullName)" }\n}\n\n# -------------------------------\n# Master selection helpers\n# -------------------------------\n\nfunction List-Masters {\n    foreach ($st in $stencils) {\n        Write-Host ("Stencil\/Doc: {0}" -f $st.Name) -ForegroundColor Cyan\n        foreach ($m in $st.Masters) {\n            Write-Host ("  - {0} (NameU: {1})" -f $m.Name, $m.NameU)\n        }\n    }\n}\n\nfunction Get-MasterByPattern([string[]]$patterns) {\n    foreach ($st in $stencils) {\n        foreach ($m in $st.Masters) {\n            foreach ($p in $patterns) {\n                if ($m.NameU -match $p -or $m.Name -match $p) {\n                    Write-Host ("Selected master '{0}' from '{1}' for pattern '{2}'" -f $m.Name, $st.Name, $p) -ForegroundColor Green\n                    return $m\n                }\n            }\n        }\n    }\n    return $null\n}\n\n# Drop master centered at x,y; keep default size; label it\nfunction Add-Device([double]$x,[double]$y,[string]$label,[string[]]$patterns,[double]$fontSize=10) {\n    $m = Get-MasterByPattern $patterns\n    if ($null -eq $m) {\n        Write-Warning ("No master matched patterns: {0}. Using fallback rectangle." -f ($patterns -join ", "))\n        $w = 2.0; $h = 1.2\n        $shape = $page.DrawRectangle($x - ($w\/2), $y - ($h\/2), $x + ($w\/2), $y + ($h\/2))\n    } else {\n        $shape = $page.Drop($m, $x, $y)\n    }\n    $shape.Text = $label\n    $shape.CellsU("Char.Size").FormulaU = "$fontSize pt"\n    return $shape\n}\n\n# Simple transparent containers (thin gray outline; sent behind shapes)\nfunction Add-Container([double]$x,[double]$y,[double]$w,[double]$h,[string]$text) {\n    $shape = $page.DrawRectangle($x, $y, $x + $w, $y + $h)\n    $shape.CellsU("LineColor").FormulaU = "RGB(180,180,180)"\n    $shape.CellsU("LineWeight").FormulaU = "1 pt"\n    $shape.CellsU("FillForegnd").FormulaU = "RGB(255,255,255)"\n    $shape.CellsU("FillForegndTrans").ResultIU = 1.0\n    $shape.Text = $text\n    $shape.CellsU("Char.Size").FormulaU = "12 pt"\n    try { $shape.SendToBack() } catch {}\n    return $shape\n}\n\n# Connector\nfunction Connect($fromShape,$toShape,[string]$text="") {\n    $conn = $page.Drop($visio.Application.ConnectorToolDataObject, 0, 0)\n    $conn.CellsU("LineColor").FormulaU = "RGB(60,60,60)"\n    $conn.CellsU("LineWeight").FormulaU = "0.75 pt"\n    $fromShape.AutoConnect($toShape, 0, $conn)\n    if ($text) { $conn.Text = $text }\n    return $conn\n}\n\n# -------------------------------\n# Diagram content\n# -------------------------------\n\n# Title\n$title = $page.DrawRectangle(1.0, 13.4, 21.0, 13.9)\n$title.Text = "Web App Architecture: Firewall -> Load Balancer -> Web Servers -> Database"\n$title.CellsU("Char.Size").FormulaU = "14 pt"\n\n# Patterns for official icons (broad to match common stencils)\n$patFirewall    = @("Firewall|Security|Shield|Azure.*Firewall")\n$patLoadBalancer= @("Load.*Balancer|Application.*Gateway|LB|Azure.*Load.*Balancer")\n$patWebServer   = @("Web.*Server|IIS|Server(?! Rack)|Computer|Windows.*Server")\n$patDatabase    = @("Database|SQL|Azure.*SQL|DB|Cylinder")\n\n# Containers (optional zones)\n$dmz     = Add-Container 1.0 10.8 20.0 2.0 "DMZ (Edge\/Ingress)"\n$webtier = Add-Container 4.0 6.8 14.0 3.2 "Web Tier"\n$dbtier  = Add-Container 8.0 3.5 10.0 2.8 "Database Tier"\n$clients = Add-Container 1.0 1.0 6.0 2.2 "Clients"\n\n# Devices (kept at native size; spaced widely)\n# Edge\/Ingress\n$fw      = Add-Device 3.0 11.8 "Firewall" $patFirewall 10\n$lb      = Add-Device 8.0 11.8 "Load Balancer" $patLoadBalancer 10\n\n# Web servers (pair)\n$web1    = Add-Device 9.5 8.0 "Web Server 1\\nIIS" $patWebServer 10\n$web2    = Add-Device 13.5 8.0 "Web Server 2\\nIIS" $patWebServer 10\n\n# Database\n$db      = Add-Device 13.0 4.6 "Database\\nSQL" $patDatabase 10\n\n# Clients\n$client1 = Add-Device 2.0 1.8 "Client\\nPC" @("Desktop|PC|Computer|Laptop") 10\n$client2 = Add-Device 5.0 1.8 "Client\\nServer" @("Server(?! Rack)|Windows.*Server|Computer") 10\n\n# Connectors (flow: clients -> firewall -> LB -> web servers -> database)\nConnect $client1 $fw "HTTPS"\nConnect $client2 $fw "HTTPS"\nConnect $fw $lb "Allow: 443"\nConnect $lb $web1 "HTTP\/HTTPS"\nConnect $lb $web2 "HTTP\/HTTPS"\nConnect $web1 $db "SQL (1433\/Encrypted)"\nConnect $web2 $db "SQL (1433\/Encrypted)"\n\n# Save\n$doc.SaveAs($outPath)\nWrite-Host "Saved Visio to: $outPath"\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
I had to create a number of Visio diagrams for a new project. Since Blender has a Python API, I wondered if I could do something similar with Visio. There does appear to be an VSDX library for Python, I also found that Powershell can just control the Visio instance on my laptop. This is …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[622,825],"class_list":["post-11900","post","type-post","status-publish","format-standard","hentry","category-system-administration","tag-powershell","tag-visio"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11900"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11900\/revisions"}],"predecessor-version":[{"id":11901,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11900\/revisions\/11901"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}