SHIFT

--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools


Sidebar

Recently Changed Pages:

View All Pages


View All Tags


LinkedIn




WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.


Pages with comments

View All Comments

powershellconvertxlsxtocsvwithdelimiter

PowerShell: Convert Excel File to CSV with Special Delimiter

Or actually, save an excel file as CSV and then recreate it with a specific delimiter:

cd "D:\filedir\"
$Excel = New-Object -ComObject Excel.Application
$Excel.visible = $false
$Excel.DisplayAlerts = $False
$file = "D:\filedir\excelfile.xlsx"
$csv = "D:\filedir\excelfile.csv"
$csvfinal = "D:\filedir\excelfilefinal.csv"
$workfile = $Excel.Workbooks.open($file)
$Sheet = $workfile.Worksheets.Item(1)
$Sheet.Activate()
$Sheet.SaveAs($csv,[Microsoft.Office.Interop.Excel.XlFileFormat]::xlCSVWindows)
$workfile.Close()
sleep 5
$Excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)
Import-Csv $csv | Export-Csv $csvfinal -Delimiter ";" -NoTypeInformation
You could leave a comment if you were logged in.
powershellconvertxlsxtocsvwithdelimiter.txt · Last modified: 2021/09/24 00:25 (external edit)