Sunday, August 18, 2013

PowerShell: Clean I-Suite Custom Report extraneous character in number field

$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