Hi,
with a few lines Powershell code it is possible to export a Excel Workbook as a csv file.
Define your excel list
1 2 | $sExcelFile="D:\temp\ExcelFile.xlsx"$sCSVFile="D:\temp\list.csv" |
Open Excel using DCOM
Continue reading Powershell: Export a Excel Worksheet as csv file
Hi,
here are the code snippets to list all members of an Active Directory Group.
Some constants
1 2 3 4 | # Define LDAP search root, the Global catalog of the domain$sLDAPSearchRoot="LDAP://yourDomain.com:3268"# The Groupname to looking for$sGroupName="USR_GRP_IN_AD" |
Continue reading Powershell: List members of an Active Directory Group
Hi,
when you want to execute your PowerCli script you have to start the “VMware vSphere PowerCLI” shell before. But, for example Schedule Tasks, it whould be nice that the script load the PowerCli environment itself. Then you simply have to start your script like this
%Systemroot%\System32\WindowsPowerShell\v1.0\powershell.exe -File YourPowerCliScript.ps1
To load the PowerCli script Environent in your powershell script add this lines at the top of your script.
Continue reading VMware: PowerCli Scripts in native Powershell
Hi,
a long time ago I wrote a Menu function for quickly choose predefined options in a script. An example
Source the menu.ps1 in your script and call fShowMenu. This will show the menu. The function needs 2 parameters:
Parameter 1: The menu title as string
Parameter 2: A hashtable with the Menuentries. The key of an Menuitem is returned by the function the corresponding value is shown at the menu.
1 2 3 4 | # Source the file. .\menu.ps1# Call Menu funtionfShowMenu "Choose your favorite Band" @{"sl"="Slayer";"me"="Metallica";"ex"="Exodus";"an"="Anthrax"} |
Hi,
if you tried to save a word or excel document as another format you got an error. For example, if you want to convert a CSV File to a Excel workbook and save it in Excel 95/97/2003 format.
1 2 3 4 5 6 7 8 9 10 11 12 | [reflection.assembly]::LoadWithPartialName("Microsoft.Office.InterOp.Excel")$oExcel = New-Object -ComObject "Excel.Application"$sCSVFile="D:\temp\ImportFile.csv"$oExcel.Visible = $true$oCSVWorkbook=$oExcel.Workbooks.Add()$oExcel.Workbooks.OpenText($sCSVFile)$oCSVWorkbook.SaveAs("D:\temp\test.xls",[Microsoft.Office.Interop.Excel.XlFileFormat]::xlExcel9795)Exception calling "SaveAs" with "1" argument(s): "SaveAs method of Workbook class failed"At D:\test\CSV2Excel.ps1:29 char:20+ $xl_workbook.SaveAs <<<< ("D:\Temp\test.xls") + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : ComMethodTargetInvocation |
Continue reading Powershell: Error while calling the SaveAs Method of some Office Applications