Powershell export csv system.object

by

Exporting System.Objects to CSV using PowerShell

In PowerShell, you can use the Export-Csv cmdlet to export System.Objects to a CSV (Comma Separated Values) file. This allows you to easily store and share structured data in a standardized format.

Syntax

The basic syntax for exporting System.Objects to CSV is as follows:

  $objects | Export-Csv -Path "path\to\output.csv" -NoTypeInformation

Here, $objects represents the System.Objects that you want to export, and "path\to\output.csv" is the file path where you want to save the CSV file. The -NoTypeInformation parameter is used to exclude the type information from being added to the CSV file.

Example

Let’s say you have an array of System.Objects called $users, which contains user information like username, email, and age. You can export this array to a CSV file using the following code:

  $users = @()
  $user1 = [PSCustomObject]@{
    Username = "john_doe"
    Email = "john.doe@example.com"
    Age = 30
  }
  $user2 = [PSCustomObject]@{
    Username = "jane_doe"
    Email = "jane.doe@example.com"
    Age = 25
  }
  $users += $user1
  $users += $user2
  
  $users | Export-Csv -Path "C:\Users\Username\Documents\users.csv" -NoTypeInformation

In this example, the $users array is populated with two user objects. Each user object is created using the [PSCustomObject] type accelerator to define the properties (Username, Email, and Age) and their values. The two user objects are then added to the $users array. Finally, the $users array is exported to a CSV file located at “C:\Users\Username\Documents\users.csv” without including type information.

After running this script, a CSV file named “users.csv” will be created with the following content:

  Username,Email,Age
john_doe,john.doe@example.com,30
jane_doe,jane.doe@example.com,25

This CSV file can then be easily imported into other systems or analyzed using tools that support CSV format, making it a convenient way to share structured data.

Leave a comment