Export-CSV – Alkane Solutions

Export Data to a CSV and Maintain the Column Order

This post provides a simple example of how we can export data to a CSV and maintain the column order: $csvFile = "c:\temp\alkane.csv" $exampledata = @(@("John","37"),@("Peter","14"),@("Michelle","22"),@("Abdul","31"),@("Roger","22"),@("Rachel","50")) $csvwrapper = @() foreach($person in $exampledata) { $name = $person[0] $age = $person[1] #append...

March 3, 2021

PowerShell

Invoke-Sqlcmd Returns Columns RowError and HasErrors

I’ve been performing some SQL queries recently using PowerShell and Invoke-SqlCmd, but I’ve noticed that by default Invoke-Sqlcmd returns columns RowError and HasErrors. Here is a simple example of returning a list of devices (a single column of data) from...

November 21, 2018

PowerShell

Export to CSV using PowerShell and Dynamic Data

This post explains how to export to CSV using PowerShell and dynamic data. I find that hashtables are quite useful for various scenarios when scripting in PowerShell. We can also utilise them when exporting data using Export-CSV. I provide two...

May 4, 2017

Tag: Export-CSV

Export Data to a CSV and Maintain the Column Order

Invoke-Sqlcmd Returns Columns RowError and HasErrors

Export to CSV using PowerShell and Dynamic Data

PowerShell Script Support for Installing and Uninstalling Intune Win32 Applications

Use PowerShell to Read MSI Windows Installer Properties

Evergreen Application Packaging converting Winget to MSIX

Measured Growth

Easy integration with partners

Give us a call

Send us a message