Solved

PowerShell Script to export to HTML to MS Word Format

Posted on 2016-08-23
10
108 Views
Last Modified: 2016-09-20
Hi, All.

I created a script to document AD information using consolidated PowerShell code for our environment to export to HTML.

Kindly see attached file.

I would like to seek support on how can I convert this to export from HTML to MS Word Format.

Regards,
0
Comment
Question by:BillyDy
10 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 41766638
You haven't posted a file, but an html file can be opened in Word and then saved as a Word document.

Because of the difference between the objectives of a Word document and a Web page, the appearance is unlikely to be the same.
0
 
LVL 17

Assisted Solution

by:xtermie
xtermie earned 250 total points
ID: 41766648
As Graham says, Word can open HTML but it wont be as well formatted
appearance is unlikely to be the same

A good option is to use an API like Docverter. Docverter will allow you to convert HTML to PDF or DOCX using an API.

Also you can try following the steps here which have proved quite helpful to me in similar cases:
https://weblogs.asp.net/dixin/convert-html-to-well-formatted-microsoft-word-document
0
 
LVL 51

Accepted Solution

by:
Bill Prew earned 250 total points
ID: 41766753
One other thought, if you already have a script producing the right data, and just want it in DOC format instead of HTML, why not just adjust the script to format and write to a DOC file rather than HTML?  It will take a bit more work but you can use Automation with Word to create a Word document and then save it in Powershell.  Here is a sample of the technique.

https://www.petri.com/generate-microsoft-word-document-powershell

~bp
0
 

Author Comment

by:BillyDy
ID: 41767083
Thanks guy but I am not a programmer and I cannot seems to understand how to start to code the same  information and format/rendering as my HTML Exporting report script.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 51

Expert Comment

by:Bill Prew
ID: 41767110
In the original question post, you said "see attached file", but there was no file attached.  Did you mean to share the script you created?

~bp
0
 

Author Comment

by:BillyDy
ID: 41767126
@Billy Prew,

Attached is my AD Script.

Having a hard time to build a scripts from ground up for Word Format.
Get-ADReportHTML.txt
0
 
LVL 51

Expert Comment

by:Bill Prew
ID: 41768837
This expert suggested creating a Gigs project.
Just curious, why do you need it in Word versus HTML?

Looking at your script, and the mechanics of building a Word doc from PowerShell, this feels more like a Gig than a Question at this point, it's a fair amount of work an you are asking someone here to do it for you, rather than just looking for guidance on how to do it yourself.  You might want to post it over there to see if someone wants to do it for you for a fee.

If you do, I would recommend you post the existing HTML file, and/or a sample Word document that you want to be produced instead.  Also, the approach I mentioned above depends on having Word installed on the computer running the script, is that a reasonable assumption?

~bp
0
 

Author Comment

by:BillyDy
ID: 41785527
Thank you Xtermie and Bill Prew. I have made a separate script for this work effort,
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now