Search PowerShell packages: ImportExcel 2.2.7 New-ExcelChart.ps1 function New-ExcelChart { param( $Title="Chart Title", $Header, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="ColumnStacked", $XRange, $YRange, $Width=500, $Height=350, $Row=0, $RowOffSetPixels=10, $Column=6, $Co...
Public/Set-ExcelRange.ps1 function Set-ExcelRange { [CmdletBinding()] [Alias("Set-Format")] [Diagnostics.CodeAnalysis.SuppressMessageAttribute('PSUseShouldProcessForStateChangingFunctions', '',Justification='Does not change system state')] param( [Parameter(ValueFromPipeline = $true,Position=0)] [...
ExcelマクロのVBAソースコードをAzure DevOpsでバージョン管理する方法共有フォルダ上にアドインフォルダを作成共有フォルダ上にアドインフォルダを作る時は、GitHub/Azure DevOps上のリモートリポジトリをgit cloneすればよいです。powershell cd <共有フォルダ上のアドイン置き場> git clone...
Search PowerShell packages: ImportExcel 7.8.6 Public/Copy-ExcelWorksheet.ps1 function Copy-ExcelWorksheet { [CmdletBinding()] param( [Parameter(Mandatory = $true,ValueFromPipeline=$true)] [Alias('SourceWorkbook')] $SourceObject, $SourceWorksheet = 1 , [Parameter(Mandatory = $true)] $Destination...
Save-Excel.ps1 functionSave-Excel{ <# .SYNOPSIS Save an OfficeOpenXml ExcelPackage .DESCRIPTION Save an OfficeOpenXml ExcelPackage .PARAMETER Excel An ExcelPackage object to close .PARAMETER Path If specified, save as this path .PARAMETER Close ...
Search PowerShell packages: ImportExcel 2.2.4 Get-ExcelSheetInfo.ps1 Function Get-ExcelSheetInfo { <# .SYNOPSIS Get worksheet names and their indices of an Excel workbook. .DESCRIPTION The Get-ExcelSheetInfo cmdlet gets worksheet names and their indices of an Excel workbook. .PARAMETER ...
Search PowerShell packages: ImportExcel 2.2.7 Export-Excel.ps1 function Export-Excel { <# .Synopsis .Example gsv | Export-Excel .\test.xlsx .Example ps | Export-Excel .\test.xlsx -show\ .Example ps | Export-Excel .\test.xlsx -WorkSheetname Processes -IncludePivotTable -Show -...
Search PowerShell packages: ImportExcel 7.8.6 Public/Import-Excel.ps1 function Import-Excel { [CmdLetBinding()] [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSAvoidUsingPlainTextForPassword", "")] [Diagnostics.CodeAnalysis.SuppressMessageAttribute('PSPossibleIncorrectUsageOfAssignmentOperator', '', Just...
Public/ConvertTo-ExcelXlsx.ps1 functionConvertTo-ExcelXlsx{ [CmdletBinding()] param ( [parameter(Mandatory=$true,ValueFromPipeline)] [string]$Path, [parameter(Mandatory=$false)] [switch]$Force ) process{ if(-Not($Path|Test-Path)){ throw"File not found"...
Export-ExcelSheet.ps1 functionExport-ExcelSheet{ [CmdletBinding()] param ( [Parameter(Mandatory=$true)] [String]$Path, [String]$OutputPath='.\', [String]$SheetName, [ValidateSet('ASCII','BigEndianUniCode','Default','OEM','UniCode','UTF32','UTF7','UTF8')] ...