Hallo Peter,
danke für die Blumen ;-) . Die Excel Importfunktion habe ich geklaut, nämlich hier:
http://podlisk.wordpress.com/2011/11/20/import-excel-spreadsheet-into-powershell/
cls
function Import-Excel
{
param (
[string]$FileName,
[string]$WorksheetName,
[bool]$DisplayProgress = $true
)
if ($FileName -eq "") {
throw "Please provide path to the Excel file"
Exit
}
if (-not (Test-Path $FileName)) {
throw "Path '$FileName' does not exist."
exit
}
$FileName = Resolve-Path $FileName
$excel = New-Object -com "Excel.Application"
$excel.Visible = $false
$workbook = $excel.workbooks.open($FileName)
if (-not $WorksheetName) {
Write-Warning "Defaulting to the first worksheet in workbook."
$sheet = $workbook.ActiveSheet
} else {
$sheet = $workbook.Sheets.Item($WorksheetName)
}
if (-not $sheet)
{
throw "Unable to open worksheet $WorksheetName"
exit
}
$sheetName = $sheet.Name
$columns = $sheet.UsedRange.Columns.Count
$lines = $sheet.UsedRange.Rows.Count
Write-Warning "Worksheet $sheetName contains $columns columns and $lines lines of data"
$fields = @()
for ($column = 1; $column -le $columns; $column ++) {
$fieldName = $sheet.Cells.Item.Invoke(1, $column).Value2
if ($fieldName -eq $null) {
$fieldName = "Column" + $column.ToString()
}
$fields += $fieldName
}
$line = 2
for ($line = 2; $line -le $lines; $line ++) {
$values = New-Object object[] $columns
for ($column = 1; $column -le $columns; $column++) {
$values[$column - 1] = $sheet.Cells.Item.Invoke($line, $column).Value2
}
$row = New-Object psobject
$fields | foreach-object -begin {$i = 0} -process {
$row | Add-Member -MemberType noteproperty -Name $fields[$i] -Value $values[$i]; $i++
}
$row
$percents = [math]::round((($line/$lines) * 100), 0)
if ($DisplayProgress) {
Write-Progress -Activity:"Importing from Excel file $FileName" -Status:"Imported $line of total $lines lines ($percents%)" -PercentComplete:$percents
}
}
$workbook.Close()
$excel.Quit()
}
$ImportArrayExcel = import-excel c:\temp\Matrix_Trevaco_anonym.xlsx
$i = 0
forEach ($line in $ImportArrayExcel)
{
$ArrayRights = $ImportArrayExcel.SyncRoot[$i]
$i ++
}
Nun möchte ich die Werte vom $ImportArrayExcel in ein weiteres Array einfügen, so dass den Benutzernamen in eine Variable abfüllen kann, ebenso die Gruppe in eine Variable Packen + die Berechtigung (C oder R), damit ich dann in einer Schlaufe zum Beispiel
ein add-adgroupmember $Gruppe"-"$Berechtigung $User machen kann..
Gruss
Florian
Schaue auf niemanden herab, es sei denn, du willst ihm aufhelfen...
Excel / Powershell Zugriff auf Matrix
