Mit Powershell Excel-Diagramme erzeugen

Hier ein kleines Beispiel, wie man per Powershell-Code ein Excel-Diagramm erzeugen lassen kann:

$excel = New-object -comobject Excel.Application
$excel.Visible = $true
$excel.DisplayAlerts = $false
$workbook = $excel.Workbooks.Add()
$sheet = $workbook.Worksheets.Item(1)
$sheet.Name = 'Hallo Welt'
foreach ($i in 1..25){
    $sheet.cells.item($i,1) = $i
    $sheet.cells.item($i,2) = $i*2
# Bar Chart
# Datenherkunft
$range = $sheet.range('a1:a25')
# Chart-Variable anlegen
$ch = $sheet.shapes.addChart().chart
# Typ zuweisen (Bar Chart)
$ch.chartType = 58
# Daten zuweisen


Uwe Ziegenhagen likes LaTeX and Python, sometimes even combined. Do you like my content and would like to thank me for it? Consider making a small donation to my local fablab, the Dingfabrik Köln. Details on how to donate can be found here Spenden für die Dingfabrik.

More Posts - Website