Sort Excel Worksheets with PowerShell and .NET. Using PowerShell, we access an Excel workbook with many sheets. We use .NET collections (ArrayList) to gather the worksheet names and sort them. Then we re-arrange the Worksheets in the Excel workbook so they are in alphabetical order.
Tags: Sort Excel Worksheets with PowerShell and .NET, Microsoft Excel (Software), Microsoft, VBA, Visual Basic for Applications, COM, Component Object Model, Microsoft Windows, PowerShell, PowerShell V3, PowerShell V2, Computer, tutorial, technology, .NET, ArrayList, System.Collections.ArrayList, sorting, New-Object, -ComObject, -ProgID, Microsoft Office automation, Microsoft Office (Software)