Skip to content

Instantly share code, notes, and snippets.

@wildbillcat

wildbillcat/ConvertFromExcetoCsvl.ps1

Created October 11, 2016 13:02
Show Gist options
  • Save wildbillcat/2db4307a3f8e76ff53cdcfcbf604e2f0 to your computer and use it in GitHub Desktop.
Save wildbillcat/2db4307a3f8e76ff53cdcfcbf604e2f0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ConvertFromExcetoCsvl.ps1
$objExcel = New-Object -ComObject Excel.Application
$objworkbook=$objExcel.Workbooks.Open("C:\file.xls")
$objworkbook.SaveAs("C:\Dest.csv",6) # 6 is the code for .CSV
$objworkbook.Close($false)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment