Solved

PowerShell Script to export to HTML to MS Word Format

Posted on 2016-08-23
10
222 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 18

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 53

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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
 
LVL 53

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 53

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In-place Upgrading Dirsync to Azure AD Connect
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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