Convert a .csv file to xlsx (despite the name)
Data Wrangling\Convert-CsvToXls.ps1
Convert-CsvToXls [[-Path] <String>] [-DeleteSource] [-Delimiter <String>] [-Name <String>] [-Show]
The implementation is a combination of two functions I found on StackOverflow and GitHub/Gist (see Links).
Convert-CsvToXls c:\test.csv
$csvFile | Convert-CsvToXls
Path of the CSV file to be converted (accepts pipeline input via dir). If no path is provided an open file dialog is opened to select the path.
Type: String
Parameter Sets: (All)
Aliases: FullName
Required: False
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: FalseSwitch to indicate wheter the source CSV file will be deleted.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseDelimiter used in the CSV. Defaults to system settings delimiter.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe name for the resulting excel worksheet. Defaults to the file base name.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSwitch paramenter, if set the resulting Excel file will be opened.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: Falsehttps://gist.github.com/XPlantefeve/75bde89c6967569d218f
https://stackoverflow.com/questions/17688468/how-to-export-a-csv-to-excel-using-powershell