Private/Wissen/X_Technology/X25_XLSX.ps1
<#
# Excel Alles rund um das Thema Office-Dokumente - **Hashtags** XLSX Office Excel - **Version** 2020.02.27 #> $xls = New-Object -ComObject "Excel.Application" $xls.Visible = $false # Debugging $wb = $xls.Workbooks.Add() $ws = $wb.Worksheets.Add() $a1 = $ws.Range("A1") $a1.Value2 = "PowerShell ist spitze!" $wb.SaveAs("c:\temp\meinmappe.xlsx") $xls.Quit() # ! NACHTEIL (Excel bzw. Office muss installiert sein, Office PIA 2010 downloaden) # ? BESSER CSV oder 'OpenXML for Office' # ? ODER: PowerShell module to import/export Excel spreadsheets, without Excel: https://www.powershellgallery.com/packages/ImportExcel # Über das Module ImportExcel können Daten nach oder von Excel importiert / exportiert werden OHNE das Excel selber installiert sein muss. # TIPP - Videos https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq Install-Module -Name 'ImportExcel' -Scope 'CurrentUser' -SkipPublisherCheck -Force Get-Command -Module 'ImportExcel' Remove-Item -Path 'C:\Temp\CurrentProcesses.XlsX' -Force Get-Process | Export-Excel 'C:\Temp\CurrentProcesses.XlsX' -WorksheetName 'Processes' -ChartType 'PieExploded3D' -IncludePivotChart -IncludePivotTable -Show -PivotRows 'Company' -PivotData 'PM' Start-Process -FilePath 'C:\Temp\CurrentProcesses.XlsX' -Wait #-------------------------------- #region Excel-Daten importieren # Module: ImportExcel - PowerShell module to import/export Excel spreadsheets, without Excel. Check out the How To Videos https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq Install-Module -Name "ImportExcel" -Scope "CurrentUser" -SkipPublisherCheck -Force Get-Command -Module "ImportExcel" Get-Help -Name "Import-Excel" -ShowWindow Get-Process | Export-Excel -Path "C:\Temp\CurrentProcs.XlsX" -WorksheetName "Current Processes" $importRows = Import-Excel -Path "C:\Temp\CurrentProcs.XlsX" -WorksheetName "Current Processes" $importRows | Out-GridView $importRows | Get-Member #endregion |