For most of the automation and report we will prefer and use Excel , instead of excel her we look at how you can use Word with PowerShell to create a document.One of the first things that you need to do is ensure that you have Word installed on your computer. Once you have that verified, we can begin by creating a COM object connection to Word.Application, which will help us to begin the interacting with Word.
Running the below script that was just looking to create the document without showing anything, and making Visible property on the object to True. So after creating this object ($word) which will help to interacting with Word and its ready for our operations.
$word=new-object -ComObject “Word.Application”
$Word.Visible = $True
Before using edit on the word document before that, we need to add a document to our Word object and then select it so we can being adding text to it.
$doc = $word.documents.Add()
$myDoc = $word.Selection
Now we are ready to begin to edit and start writing in our Word document.Here i am going to generate the comments document from the PowerShell script, so you can achieve this using the TypeText() method, which is available on $myDoc object.
If we use of the TypeText method, the we need to understand the text will appear on the same line as the rest of the text. So we need to use the TypeParagraph method which use to start on a new line like break tag in HTML and then you use TypeText to begin writing on a brand-new line.
$myDoc.Style=”Strong”
$myDoc.TypeParagraph()
$myDoc.TypeText(“Hi All, “)
$myDoc.TypeParagraph()
$myDoc.TypeText(“This is Message from dotnet-helpers.com “)
Final Code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
####################################################### #Project : Writing in Word doc using Powershell #Developer : Thiyagu S (dotnet-helpers.com) #Tools : PowerShell 5.1.15063.1155 #E-Mail : mail2thiyaguji@gmail.com ####################################################### $savepath="C:\dotnet-helpers\ReviewCommends.docx" $word=new-object -ComObject "Word.Application" $Word.Visible = $True $doc = $word.documents.Add() $myDoc = $word.Selection $myDoc.Style="Strong" $myDoc.Font.Bold = 1 $myDoc.TypeParagraph() $myDoc.TypeText("Hi All, ") $myDoc.TypeParagraph() $myDoc.TypeText("This is Message from dotnet-helpers.com ") $myDoc.Style="Normal" $myDoc.Font.Italic = 1 $myDoc.TypeParagraph() $myDoc.TypeText("Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes,nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel,aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae") $myDoc.TypeParagraph() $myDoc.TypeParagraph() $myDoc.TypeText("Thanks") $myDoc.TypeParagraph() $myDoc.Style="Strong" $myDoc.TypeText("Thiyagu S") $myDoc.TypeParagraph() $Date = Get-Date $myDoc.TypeText("Date: $($Date)") $doc.SaveAs([ref]$savepath) $doc.Close() $word.quit() Invoke-Item $savepath #Here you want to release all of these objects, so here we call the ReleaseComObject method, so we doing this each of objects which created. #then you need to call garbage collection to scavenge memory, and I remove the variables. [System.Runtime.Interopservices.Marshal]::ReleaseComObject($doc) | Out-Null [System.Runtime.Interopservices.Marshal]::ReleaseComObject($word) | Out-Null Remove-Variable doc,Word [gc]::collect() [gc]::WaitForPendingFinalizers() |
OUTPUT
Leave A Comment