PowerShell.com
Library » Script Library » Using .Net » Slideshow

Using .Net Slideshow

  1. Function convertToCSV { 
  2.   Param ([string]$toConvert) 
  3.    
  4.      
  5.     $excel = New-Object -ComObject "Excel.Application"  
  6.     $workBook = $excel.workbooks.open($toConvert) 
  7.     if($toConvert -match ".xlsx"){ 
  8.     $global:target = $toConvert.replace(".xlsx",".csv")} 
  9.     else{$target = $toConvert.replace(".xls",".csv")} 
  10.     $workBook.SaveAs($target,6)  
  11.     $excel.displayalerts=$False  
  12.     $excel.quit()  
  13.  
  14. } 
  15.  
  16.  
  17. $toConvert = Read-Host "Type the path of the excel file" 
  18.  
  19. convertToCSV $toConvert 
  20.  
  21. $converted = Import-Csv -Path $target 
  22.  
  23. Get-Process | Export-Csv "d:\myTools\Compare\toCompare.csv"         ### 
  24.                                                                     ### Change this for your needs. Get-Process is just an example. 
  25. $toCompare = Import-Csv -Path "d:\myTools\Compare\toCompare.csv"    ### 
  26.  
  27. $newCSV = New-Object System.Collections.ArrayList 
  28.  
  29. for($i=0;$i -lt $converted.length; $i++){ 
  30.  
  31. for($j=0; $j -lt $toCompare.length; $j++){ 
  32.  
  33. if($converted[$i].processname -eq $toCompare[$j].processname){ ## Also change here to attend your requirements 
  34.  
  35. if(!$newCSV.contains($converted[$i])){ 
  36.  
  37. $newCSV.add($converted[$i]) | Out-Null}} 
  38.  
  39. }} 
  40.  
  41. $newCSV | Export-Csv d:\myTools\Compare\newCSV.csv  ## Change here as well. 
 
Loading...
View all files
Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.