$infile = "$home\desktop\customreport.xls"
$outcsv = "$home\desktop\customreport.csv"
$xlCSV = 6
$Excel = New-Object -Com Excel.Application
$Excel.visible = $False
$Excel.displayalerts=$False
$WorkBook = $Excel.Workbooks.Open($infile)
$Workbook.SaveAs($outcsv,$xlCSV)
$Excel.quit()
$Excel = New-Object -Com Excel.Application
$Excel.visible = $False
$Excel.displayalerts=$False
$WorkBook = $Excel.Workbooks.Open($outcsv)
$Workbook.SaveAs($infile,1)
$Excel.quit()
del $outcsv
No comments:
Post a Comment