2009-12-12, 21:32
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
$ch.setSourceData($range) |
$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
$ch.setSourceData($range)
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