Import-Xlsx

Being satisfied with being able to easily export PowerShell objects directly to Excel I was wondering if I could do the reverse as well. Of course, importing from Excel would be rather arbitrary once you know how to export to Excel. Simply reverse the process. Basically that is true. However, … Continue reading

Export-Xlsx

While I was happy with the existing Export-Csv Cmdlet I missed some of the Excel features, like autofit and autofilter. Sure, I can open any CSV file in Excel and then apply the autofilter and autofit to get what I want. But that would mean more clicking. So I thought … Continue reading