What's new 7.1.0
Fixes, Updates and new Examples
Fixed
- Odd behavior on the return of Import-Excel function #792
- Export-Excel -FreezeTopRow with -Title #795
- Not importing when first row contains a 0 in a column #802
Updated
- Add
-AsDatesupport toImport-ExcelandConvertFrom-ExcelSheet
New Examples
| PS1 | Description | Link |
|---|---|---|
| Pester-To-XLSx | Runs Pester, collects the results, enriches it, and exports it to Excel | Pester-To-XLSx.ps1 |
| DSUM | Sums up the numbers in a field (column) of records in a list or database that match conditions that you specify. | DSUM.ps1 |
| VLookup | Setups up a sheet, you enter the name of an item and the amount is looked up | VLOOKUP.ps1 |