?
Solved

PowerShell Script to export to HTML to MS Word Format

Posted on 2016-08-23
10
Medium Priority
?
356 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 1000 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 56

Accepted Solution

by:
Bill Prew earned 1000 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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 56

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 56

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

801 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