-
-
Save pa-0/2e8854e240b30e4d52406220d33bd24c to your computer and use it in GitHub Desktop.
Revisions
-
dfinke renamed this gist
Jan 3, 2016 . 1 changed file with 0 additions and 0 deletions.There are no files selected for viewing
File renamed without changes. -
dfinke revised this gist
Jan 3, 2016 . 1 changed file with 4 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -4,4 +4,7 @@ rm srv1.xlsx -ErrorAction Ignore Export-Excel srv1.xlsx -AutoSize -TableName table -Show # Read the new spreadsheet # Import-Excel .\srv1.xlsx # read, export to csv # Import-Excel .\srv1.xlsx | Export-Csv -NotType srv1.csv -
dfinke created this gist
Jan 3, 2016 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,7 @@ rm srv1.xlsx -ErrorAction Ignore [xml](gc .\srv1.mbsa) | % secscan | Export-Excel srv1.xlsx -AutoSize -TableName table -Show # Read the new spreadsheet # Import-Excel .\srv1.xlsx