Questions tagged [export-csv]

Exporting data in the CSV data format (comma-separated values). A CSV file stores tabular data (numbers and text) in plain text. Use this tag for questions regarding creating .csv files.

Exporting data in the CSV data format (comma-separated values). A CSV file stores tabular data (numbers and text) in plain text. This tag is a more specific version of the tag "csv".

The CSV file is not fully standardized therefore questions regarding compatibility and syntax may occur when creating files.

154 questions
8
votes
1 answer

Import-Csv / Export-Csv with german umlauts (ä,ö,ü)

i came across a little issue when dealing with csv-exports which contains mutated vowels like ä,ö,ü (German Language Umlaute) i simply export with Get-WinEvent -FilterHashtable @{Path=$_;ID=4627} -ErrorAction SilentlyContinue |export-csv…
Peter Core
  • 193
  • 1
  • 2
  • 16
8
votes
3 answers

Powershell Export to CSV from ForEach Loop

I'm new to Powershell but I've given it my best go. I'm trying to create a script to copy a file to the All Users Desktop of all the XP machines in an Array. The script basically says "If the machine is pingable, copy the file, if not, don't." I…
Groveham
  • 103
  • 1
  • 1
  • 8
6
votes
1 answer

How to ad export csv, excel button on vuetify data table?

I am new for vuetify and faced problem with exporting my v-data-table to excel, csv format. How can i do it. Any suggestion or reccomondation. Thank you so much.
Lkhagvasuren
  • 85
  • 1
  • 7
4
votes
1 answer

PowerShell Export-Csv can't work with UseQuotes parameter

I'm trying to start this from my Powershell script: Import-Csv -Path $filecur -Delimiter ";" | Export-Csv -Path $filenext -Delimiter ";" -NoTypeInformation -Encoding Unicode -UseQuotes Never But after executing Powershell script command promt show…
Andrey Vaulin
  • 155
  • 2
  • 8
4
votes
2 answers

Export-Csv - Access to the path 'C:\export.csv' is denied

I'm getting the information I need out of the line, although when I go to export the information, I get an error. When I run this code: get-process | Export-csv -Path "C:\export.csv" -NoTypeInformation I get this error: Export-csv : Access to the…
3
votes
2 answers

Import a CSV, run port connection, then export to new csv

I have a Sources.csv which has columns "Source," "Host" and "Port" (Source is just the name of the device I'm trying to connect to). My goal is to go line-by-line through this CSV, run a connection test to the IP and Port, then export to a new csv…
Christopher Cass
  • 817
  • 4
  • 19
  • 31
3
votes
0 answers

How to generate multiple files with one controller in spring boot

Hi I have created a spring boot application to generate csv files that fetch data from database and write them into a csv file. Also I have added the functionality to select the columns that we need from the database to be included in the csv. Now I…
3
votes
1 answer

Powershell's Export-CSV command not including header (column names) when there are no results

I have a CSV file that is used as a resource by other files. It is expected that this CSV file will always have a header row at the very minimum which specifies the expected columns. Not having this header row causes errors in the other files. In my…
3
votes
2 answers

Getting "System.Collections.Generic.List`1[System.String]" in CSV File export when data is okay on screen

I am new to PowerShell and trying to get a list of VM names and their associated IP Addresses from within Hyper-V. I am getting the information fine on the screen but when I try to export to csv all I get for the IP Addresses is…
G Beach
  • 115
  • 1
  • 3
  • 10
3
votes
1 answer

Under what circumstances would one need the information emitted when -NoTypeInformation is *not* passed to ConvertTo-Csv or Export-Csv?

It occurred to me today that, after so many years of habitually passing -NoTypeInformation to Export-Csv/ConvertTo-Csv to prevent that undesirable comment line from being emitted, perhaps Import-Csv/ConvertFrom-Csv would be able to reconstruct…
Lance U. Matthews
  • 15,725
  • 6
  • 48
  • 68
3
votes
1 answer

powershell export-csv sum column per each row

I wrote this script to output a table formatted file: $VMs = Get-AzureRmVM $vmOutput = $VMs | ForEach-Object { [PSCustomObject]@{ "VM Name" = $_.Name "VM Type" = $_.StorageProfile.osDisk.osType "VM Profile" =…
lubierzca
  • 160
  • 2
  • 14
2
votes
3 answers

Powershell export-csv .... adding row number to output just can't be that complicated

Folks, In the past I've struggled for hours trying to do something in Powershell and then have someone here answer with the simplest one line answer. I'm hoping for the same now after spending hours on this. I want to import a csv file and export…
ljg
  • 95
  • 4
2
votes
2 answers

Out-File Of ForEach With If(Test-Path ...)

$homefolder = (gci \\SERVER\homefolder | select fullname) $outfile = "$env:USERPROFILE\Desktop\Homefolder_Desktop_Redirect.csv" ForEach ($dir in $homefolder) {If(Test-Path ($dir.FullName +"\Desktop")){write-host $dir.Fullname" contains desktop"…
Nate
  • 802
  • 1
  • 8
  • 28
2
votes
1 answer

Is there any efficient way to export data from remote DolphinDB server to local?

My DolphinDB GUI is connecting to a remote server and I want to export the data to my local computer. The function saveText can only save the file to the remote machine where the server is located. I have to transfer the file using scp command. Is…
damie
  • 412
  • 2
  • 7
2
votes
0 answers

Bypass Record limit in REST API Call

I currently have a Powershell script to fetch orders through a REST API Call. The script (1) Uses the INVOKE-ResetMethod for the API call, then (2) uses the Export-CSV cmdlet to save the results in a CSV file, which works fine: $uri =…
Depth of Field
  • 307
  • 2
  • 16
1
2 3
10 11