mirror of
https://github.com/dfinke/ImportExcel.git
synced 2025-12-06 00:23:20 +00:00
16 lines
372 B
PowerShell
16 lines
372 B
PowerShell
function Enable-ExcelAutofit {
|
|
<#
|
|
.SYNOPSIS
|
|
Make all text fit the cells
|
|
|
|
.EXAMPLE
|
|
Enable-ExcelAutofit $excel.Sheet1
|
|
#>
|
|
param(
|
|
[Parameter(Mandatory)]
|
|
[OfficeOpenXml.ExcelWorksheet]$Worksheet
|
|
)
|
|
|
|
$range = Get-ExcelSheetDimensionAddress $Worksheet
|
|
$Worksheet.Cells[$range].AutoFitColumns()
|
|
} |