SHIFT

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

User Tools

Site Tools


Sidebar

Sponsor:


Recently Changed Pages:

View All Pages


View All Tags







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

PageDateDiscussionTags
2019/11/18 13:52 1 Comment

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

Discussion

Enter your comment. Wiki syntax is allowed:
D G J Q H
 
powershellconvertxlsxtocsvwithdelimiter.txt · Last modified: 2019/11/28 13:38 by sjoerd